Forum Discussion
Import data from a folder with different fileformats
Hi, In PowerQuery I extract data from multiple files from a folder. The fileformats differ: csv, xlsx. The .csv files will convert properly but the data in the .xlsx will not be recognized. W...
- Hi Hans, you'll need to do separate queries and then combine them into a 3rd.
So one set of of queries for the CSV files (using filter just to choose csv) and then one set of queries filtering for xlsx.
Then append the 2 sets assuming they need to be appended.
Hi,
As i'm just starting with PQ, it was easier to make 2 seperate queries and combine them in a 3rd. But you set me in the right direction anyway, so thanks very much for your help and the examplefile!
Regards,
Hans
Hi Hans,
I see your point, thank you for the feedback. If you have very few files in the folder with unchanged names/types separate queries work fine in any case. If bunch of files with changeable names - better to automate, otherwise maintenance overhead will be too high.
Good luck with PQ, that's nice and powerful product.