Forum Discussion

Simon_29's avatar
Simon_29
Helper II
4 years ago
Solved

The merged tables do not sort correctly

Hello, I have a problem with mergeing tables and then sorting. The tables were merged correctly. As we can see in the first table, he gives me the first 3 records in a row. It should go as in the ...
Need Help
Show and Tell
Tips and Tricks
  • Simon_29's avatar
    Simon_29
    4 years ago

    Hello,

    I found a solution. I added, before merging the query, an index column, which numbered my data from 0 to N ... When I used merge with the second table, it shuffled the whole index column, but I had it sorted again from 0 to N, so it was solved.



    Thanks for your time 🙂

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Check your applied steps in the right side of the Power Query editor and see if there's a "sort" step in there. If there is, remove the step.

 

Also, if you are using the function labeled "Merge" I would try "Append" instead.

  • Simon_29's avatar
    Simon_29
    Helper II
    4 years ago

    Hi.

    I don't have any "sort" step there. I canceled all the filters and tried to merge it again and now it doesn't give me the first 3 data below itself in the form: Badge, Badge, Badge, Name, Name, Name .. but it only gives the first 2 - Badge, Badge, Name, Name. I can't use the append because I need it to merge common values ​​for me - that is, to append values ​​from one table to another based on an ID.

    But thank u for trying 🙂