Forum Discussion

Strizzolo's avatar
Strizzolo
Advocate II
2 years ago
Solved

Does Table.Combine follow a sort?

I have two tables, A and B, which contain among others a LAST_UPDATE column and usually A is always more updated than B. I want to avoid using Table.Sort to sort because it slows down my transformations.

 

I can't find an official reference in the documentation so I ask you: if I do Table.Combine({A, B}), is the result sorted? A's data first and then B's?

  • StrizzoloWhen you apply Table.Combine({A,B}) in power query, the resulting table's order will be depend on input tables's order. For this case, A's data will be first and then B's data, maintaining the row order from the source table.

    Hope this help!!

    If this answered your question, please mark this post as a solution.

1 Reply

  • StrizzoloWhen you apply Table.Combine({A,B}) in power query, the resulting table's order will be depend on input tables's order. For this case, A's data will be first and then B's data, maintaining the row order from the source table.

    Hope this help!!

    If this answered your question, please mark this post as a solution.