The TIBCO Platform is a real-time, composable data platform that will bring together an evolving set of your TIBCO solutions - and it's available now!
A chart showing the TIBCO Platform vision
Jump to content
Forums
Ask questions and gain insight from discussions

Row count with reset formula


Brian Goodyear 2

Recommended Posts

Source data has detail records that are ordered by the header record

 

 

 

 

HeaderId

DetailId

 

 

Row 1

AAA

1234

 

 

Row 2

AAA

2345

 

 

Row 3

AAA

3456

 

 

Row 4

BBB

2345

 

 

Row 5

BBB

3453

 

 

Row 6

BBB

2587

 

 

Row 7

BBB

989

 

 

 

 

I need to get a incremental row count for each grouping, resetting to 1 for each group and looking for a solution.

 

 

 

 

 

HeaderId

DetailId

Seqnum

 

 

Row 1

AAA

1234

1

 

 

Row 2

AAA

2345

2

 

 

Row 3

AAA

3456

3

 

 

Row 4

BBB

2345

1

 

 

Row 5

BBB

3453

2

 

 

Row 6

BBB

2587

3

 

 

Row 7

BBB

989

4

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...