Brian Goodyear 2 Posted January 11, 2020 Share Posted January 11, 2020 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 More sharing options...
venkataramanan k Posted January 12, 2020 Share Posted January 12, 2020 Hi Brain, it can be achive using the "OVER" function. Ref : https://docs.tibco.com/pub/spotfire/6.5.0/doc/html/ncfe/ncfe_over_functi... Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now