Introducing the all-new TIBCO Community site!

For current users, please click "Sign In" to reset your password and access the enhanced features. If you're a first-time visitor, we extend a warm welcome—click "Sign Up" to become a part of the TIBCO Community!

If you're seeking alternative community sites, explore ibi, Jaspersoft, and Spotfire.

Jump to content

Finding a specifice value per the ranking sequence.


Recommended Posts

What im looking for is Keyword = Milk, Juice and WTR were there is a P_Factor (ex P/1.000) and there is a continuation line below ( " ). Inmy example below the milk is missing the contiuation line. I created a Rank_Sequence Column based on the sequence. Per my Rank_Sequence and Keyword, 14 should be a ". How can identify that the "is missing from Jersey Cow

 

 

 

NAME

SEQUENCE

RANK_SEQUENCE

KEYWORD

EXPRESSION

P_FACTOR

 

 

JERSEY COW

110

11

CUMS

315.797 683.321 0.0 0.0 0.0 289.244

 

 

 

JERSEY COW

120

12

START

Feb-21

 

 

 

JERSEY COW

130

13

MILK

12.89396 X R/S 6.000000 EXP P/1.1000 23.757777

1.1

 

 

JERSEY COW

180

14

START

Feb-21

 

 

 

JERSEY COW

190

15

JUICE

1.1117 X l/D 6.000000 EXP P/1.5000 25.925749

1.5

 

 

JERSEY COW

200

16

"

Z 0.246430 l/D X YRS EXP 6.000000

 

 

 

JERSEY COW

220

17

START

Feb-21

 

 

 

JERSEY COW

240

18

WTR

0.98857 ZT/D 6.000000 EXP P/1.1000 22.328213

1.1

 

 

JERSEY COW

260

19

"

X 0.03046787 B/D Z YRS EXP 6.000000

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...