Log In
Register
Home
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
Offline
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
See Answer
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
This is one of many reasons for NOT to use automatic file combiner.
However, you can simply apply a filter on the first column to remove records that contains "Date" text.
Answers Post
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
Offline
Hi Catalin
Thanks for your answer, filter solves my problem.
but curious to know what is the recommended way to do combine files ?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
Offline
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)
