Forum Discussion
Null Values for CSV
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
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
if this doesn't resolve the issue, please share sample inputs and outputs removing sensitive data
1 Reply
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
if this doesn't resolve the issue, please share sample inputs and outputs removing sensitive data