Forum Discussion
Null Values for CSV
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
Memorable Memberhi 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