I'm importing a number of CSV files that are stored in a folder.
I can get power query to import and merge them all into a long list, however if i make changes in the power query editor - > Transform Sample file. The Data query that combines all the files no longer works as I've changed the header in the sample row. i.e. the data query is looking for column 1 but i have changed the transform sample file so the first row is now the header row, its not the default column 1, 2 etc.
The changes i'm making are the original files contain a file description on row1 then the actual header on row 2. So i want to delete the first row. I then want to do a full transpose to switch columns with rows and then make the new first row the header. Having done this everything looks fine in the sample. but I can't get the combine query to run as its looking for column 1 which no longer exists. Is there a way to make power query recompile teh combine query based on the new sample file?
I can get power query to import and merge them all into a long list, however if i make changes in the power query editor - > Transform Sample file. The Data query that combines all the files no longer works as I've changed the header in the sample row. i.e. the data query is looking for column 1 but i have changed the transform sample file so the first row is now the header row, its not the default column 1, 2 etc.
The changes i'm making are the original files contain a file description on row1 then the actual header on row 2. So i want to delete the first row. I then want to do a full transpose to switch columns with rows and then make the new first row the header. Having done this everything looks fine in the sample. but I can't get the combine query to run as its looking for column 1 which no longer exists. Is there a way to make power query recompile teh combine query based on the new sample file?