Forum Discussion
Create row sequence based on row id column but retaining other column
Hi, I really need help with row sequencing based on a column (row_id) while retaining another column called 'split_desc'. There are two columns in the table - 'row_id' and 'split_desc' and they ...
Hi Anonymous. Here's a solution you could take a look at! Thanks
Hi Akash_Varuna ,
Thanks for your quick response.
I have done exact steps that you mentioned. However with your step 'Group Data', you mentioned only one column 'row_id' hence it will group and after adding index, it will produce an accurate row sequencing. However, in this process, we are missing out on the 'split_desc' column which is what I am having trouble with!
I hope you get my point.