Forum Discussion
Adding a Custom Dynamically Changing Index Column in a Table based on Another Table's Index Column
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))
Hi Codemunchkin ,
I think this should be relatively easy to do by creating a custom list in TableB based on MIN/MAX index values from TableA.
My question is: what does "until there are no more rows to be filled in Table B" mean?
Your examples don't show any existing values in TableB, so how many rows should be created in there?
And, if there are values in TableB, how do we know which row should get a 1, a 2 etc.?
Pete
What seems easy for you, is clearly not for me as I am new to power query. List.Range({min..max}, count_of_rows) should be used?
This "until there are no more rows to be filled in Table B" should be ignored as this can be dealt with later.
Pete "if there are values in TableB, how do we know which row should get a 1, a 2 etc" it always starts from 1 and then the pattern continues until all of the rows of Table A has been completed as shown in the sample output table.