Forum Discussion
Solved
Adding a Custom Dynamically Changing Index Column in a Table based on Another Table's Index Column
Hi, I have spent a lot of time trying to find a way to add an index (in Table B) based on the index values of another table (Table A). Table A is: Index | Country | 1 | USA | ...
It matters here what TableB looks like. Otherwise, you're just appending TableA to itself however many times.
If this is what you want, you can do this for 3 copies of A:
Table.Combine(List.Transform({1..3}, each TableA))
It matters here what TableB looks like. Otherwise, you're just appending TableA to itself however many times.
If this is what you want, you can do this for 3 copies of A:
Table.Combine(List.Transform({1..3}, each TableA))
Thank you so much. This did the trick!