Forum Discussion

T-Pan's avatar
T-Pan
Helper I
2 years ago
Solved

Get data from Folder, but excels with different column headers

Hello everyone,   Every week i update an power bi report with excel files which i receive from the data department. So i dicided to try to import the data from "Folder". The excel files have the sa...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi T-Pan ,

    Please try this way.
    I will show you my sample data first:

     


    Then, I do the append query first:

     


    The results are as follows:

    Then do a column merge:
    Click both column "Date_2023" and column "Date_2024":

    The final results are as follows:


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

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi T-Pan ,

Please try this way.
I will show you my sample data first:

 


Then, I do the append query first:

 


The results are as follows:

Then do a column merge:
Click both column "Date_2023" and column "Date_2024":

The final results are as follows:


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

 

T-Pan's avatar
T-Pan
Helper I
2 years ago

Also i want to ask if there is any similar way to get data from Folder, but a folder which located in Sharepoint, so every time i enter a file automatically append in my table?