Hello everyone,
I would like your help on the following subject:
Everyday I receive compressed *.zip files.
Each *.zip file that contains different files that are not the same (therefore cannot be combined with folder source in power query)
I would like to unzip my files every day and load files into the tables using their names (with parameters ?)
Indeed, it would be necessary to combine the files which have the same names: *fichier_abc*
Example :
file1_20230301.zip:
SALE_REGULATION_20230301_063354.csv
SALE_CLAIMS_20230301_070908.csv
file2_20230302.zip:
SALE_REGULATION_20230302_070314.csv
SALE_CLAIMS_20230302_063936.csv
1) I need to unzip file1_20230301.zip and file2_20230302.zip into the same folder.
2) Combine in a table SALE_REGULATION_20230301_063354.csv and SALE_CLAIMS_20230302_063936.csv
3) Combine in a table SALE_REGULATION_20230302_070314.csv and SALE_CLAIMS_20230301_070908.csv
Do you have an idea of the solution?
I followed this tutorial: http://sql10.blogspot.com/2016/06/reading-zip-files-in-powerquery-m.html
But I can't seem to adapt it to my problem.
I thank you in advance,
Cordially
