Loading data from folder and column didn't appear

[MRBranco]

Hi,

I need help to load data from folder with three files where one has a different column and this column didn't appear in the final report.

I have a folder [C:\Report] and subfolders [Joe, Mike, Paul]:

In each subfolder I have a Excel file as a report.

In 2 files (Joe and Mike) I have just two columns (Product/Sales) and the other file (Paul) I have three columns (Product/Sales/Cost).

I imported the folder and combined the Excel files:

The final report is generated

But, without the column COST.

I need to make appear the column COST.

The column is in Transform File:

But, didn't appear in the report final.

Thanks for any help.
MRBranco

[v-juanli-msft]

Hi @MRBranco 

Please follow the guide from Ashish_Mathur's video, then select "load more" below.

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

[Ashish_Mathur · Accepted solution]

Hi,

Please follow the process shown in this video to append files from multiple folders - https://www.youtube.com/watch?v=yL11ugShdrk.

Hope this helps.

[Greg_Deckler]

@MRBranco - That may be tricky. It's probably because the file that had that extra column is not the file that you used for your sample file. Problem may be that if you use it as your sample file, all of your other files will error when loading.