Forum Discussion
Create row sequence based on row id column but retaining other column
Hi Anonymous. Here's a solution you could take a look at! Thanks
Hi SundarRaj ,
This is perfect solution. It works for me.
Not sure what mistake I was doing? Could you please explain the last step (Soln) that you created. I was trying to get this step done through UI and was not getting the desire result.
Appreciate if you can explain.
Thank you
Brijesh
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