Null Values for CSV

[Anonymous]

Hi All,

I am getting multile CSV files from folder the file name have different country name and period like File1_SG_3M & File 2_CH_1M

while loading if I give file name have 1M as sample after loading 1M files shows values 3M files values are null how to overcome this issue

[adudani · Accepted solution]

hi @Anonymous ,

I think, The files combine based on the headers provided in the sample file.

If the column headers are not identical, it won't be appended correctly.

Maybe this will help

1. (12) How to Merge Excel Files with Different Headers in Power Query | List.Accumulate - YouTube

the first example is assuming you have a header mapping table

2.  (12) Combine Data From Multiple Excel Files into a Single Excel File - With Dynamic Columns and Sheets - YouTube

if this doesn't resolve the issue, please share sample inputs and outputs removing sensitive data