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 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.
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,
Thnx! Problem solved.
Regards,
Hans