Forum Discussion

Sonne's avatar
Sonne
Helper II
4 years ago
Solved

Data view

Hello, I have a problem with the view of connected data from 2 tables .  I have 2 excel files which I import :  table 1 has the following structure :  excel file 1     unique id  organis...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    4 years ago

    Hi Sonne ,

     

    In the power query, the merge logic of append is based on matching the names of the fields. Column names that do not exist in the original table will form a new column and will be null at the corresponding values.


    If you don't want to display these null values, you can refer to the following operation.


    If the problem is still not resolved, could you further describe your requirements and provide screenshots of your expectations accordingly. I will be able to answer your questions as soon as possible. Looking forward to your reply.


    Best Regards,
    Henry


    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.