Forum Discussion

RokuCap's avatar
RokuCap
Helper I
3 years ago
Solved

Merging Two Tables - Keep Order of Rows from Secondary Table in the Merged Table

I have two tables: Table A & Table B. I want to merge the Table B values to Table A but keep the row order from Table B (merging messes the row ordering). I've created a Group Rank column (based on t...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, RokuCap ;

    After we merge two table, we could sort the column.

     

    = Table.Sort(#"Expanded TableB",{{"Index", Order.Ascending}, {"TableB.Group Rank", Order.Ascending}})

     

    Then the final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-yalanwu-msft's avatar
v-yalanwu-msft
Community Support
3 years ago

Hi, RokuCap ;

After we merge two table, we could sort the column.

 

= Table.Sort(#"Expanded TableB",{{"Index", Order.Ascending}, {"TableB.Group Rank", Order.Ascending}})

 

Then the final show:


Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

RokuCap's avatar
RokuCap
Helper I
3 years ago

Thanks Yalan. This did the trick!