Forum Discussion
Helper IIAdd Index Column doesn't maintain order of previous step
Hello guys,
I have a problem with maintaining the order of each row by adding a index column.
The following table:
First the column 'Filter' is sorted in ascending order.
Based on this step, an index column should now be added. However, adding it discards the order of the previous step.
I have tried unsuccessfully to work with Table.Buffer.
Any ideas how adding an index column preserves the order of the previous step?
Kind regards
Chris
i have find the problem. Some steps before i already had sorted by column Filter. However that leeded to the mentioned problem. After delete this step all works fine. thanks
3 Replies
- Chris_23
i have find the problem. Some steps before i already had sorted by column Filter. However that leeded to the mentioned problem. After delete this step all works fine. thanks
I'm having the same problem with Table.Range(). For some reason, the function don't get the right row informed. And when I used Table.AddIndexColumn(), the order of the table rows changes completely. I have no clue why Power Query doesn't maintain the order from one step to another. It doesn't make any sense at all!
