Forum Discussion
Solved
Column Count on Data Import
Hi All I am using a MRP system that exports various businees report daily as CSV files. I have many Power Queries linked to the .CSV files in both Excel and BI. The raw reports can be amende...
Okay thanks, so I assumed as it auto fills in the first three applied steps thats the order they needed to be in.
How about inserting a step to 'remove other columns'? If you select all the columns required with ctrl mouse click or shift mouse click then right-click, the option will be there.
This translates to a Table.SelectColumns call.
Hi Yes I already have that but after the change type, i.e. after the auto populated three steps.
The source step is finding the new columns added in the data, then the promote headers is working but the change type falls over as it cant find the new columns promoted headers name. you just get this at the end of the code, , {"", type text}}) and you have to manually type in the new colum name.