In the example above, what is the easiest way to add a sequential ROW_ID column to get the result
1 000000002050
2 000000002040
3 000000002060
I tried using the Row Generation but the results were tripled...
Thank you in advance for your help!
Use the gen_row_num() function in the Query transform.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.