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
SundarRaj
Super User
Super UserSure Anonymous
1. Consider the second image. That Table shows you the step before the Indexing.
2. Table.TransformColumns helps me to get into a table, specify the column (the "All" column) on which I'd like to make alterations (in this case, add the index column).
3. After the indexing, what I'd like to do is combine all the tables and get the desired result. Table.Combine accepts Tables as list and combines them ( [ColumnName] gives me the Tables in a list format, just what Table.Combine accepts ).
If you still need clarifications, don't hesitate to ping back. Thanks!
Thank you SundarRaj