Forum Discussion
How to merge multiple CSV with different format?
Hello,
create a query for the first CSV file, edit and remove the columns for Supplier, Price and Quantity and move the Date column to the left.
Create a query for the second CSV file, remove the columns you don't need.
Create a query for the third CSV file, remove the columns you don't need. Then append the first query and then append the second query.
Close and apply.
Hello,
create a query for the first CSV file, edit and remove the columns for Supplier, Price and Quantity and move the Date column to the left.
Create a query for the second CSV file, remove the columns you don't need.
Create a query for the third CSV file, remove the columns you don't need. Then append the first query and then append the second query.
Close and apply.
Thank you very much!! 　Just tried and it worked!!