Forum Discussion
Transform a CSV file in Power Query where column headers are in separate columns from the values
Hey folks, I've tried to figure this out myself and searched everywhere for a solution, to no avail. I am exporting reports in CSV format from Microsoft Dynamics 2016 and it outputs the report da...
Hi Anonymous , See the Solution in the attached .pbix file. Look at the Power Query section for transformation steps. I seperated the headers and details then appended the detail rows to header. This should work for any number of columns you may have in your output files.
Hi Anonymous , See the Solution in the attached .pbix file. Look at the Power Query section for transformation steps. I seperated the headers and details then appended the detail rows to header. This should work for any number of columns you may have in your output files.
Fantastic amustafa, thank you very much!
Splitting it out in a Header table and Detail table and then recombining it was an inspired approach. Thank you again for the help :).