
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Tables
Operations Management
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service

October 17, 2018

Hi,
My CSV file is as below format:
Date Item Amount
2020-1-1 Apple USD 23.33
When I use Power Query to import from folder (multiple CSV files inside), I promote first row as header, but i can still see those headers (Date / Item / Amount) from 2nd 3rd CSV file populated into the combined dataset,
How can I remove them please ?
regards / Yan Tian

Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
Excel Tables
Operations Management
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service

October 17, 2018



November 8, 2013

Attached a sample file that reads a folder with csv files.
The path to the folder can be set in settings sheet, then just refresh the data table.
One of the most important advantages is that you can have totally different headers in the csv files, all headers from all csv files will be detected everytime.
The automatic query adds a function that reads a sample file (the first in folder), will ignore other headers from the rest of the csv files.
1 Guest(s)
