Forum Discussion

ViorelCa's avatar
ViorelCa
Helper I
8 years ago
Solved

Power Query - duplicates table data after Custom Expand Data (import files from Folder)

Dear Coleagues,   I have to import 7 excel files (each with identical data structure, one for each Brand) from a folder and combine them into one single table, while maintaining the file name into ...
Need Help
ViorelCa's avatar
ViorelCa
Helper I
8 years ago

Dear Xiaoxin Sheng Anonymous,

 

Thanks a lot for your reply.

 

I have finally managed to solve the issue by applying different steps (by creating a function when importing one Excel file and then applying this function for importing the Folder with all Excel files), based on this solution:

 

http://datapigtechnologies.com/blog/index.php/using-power-query-to-combine-data-from-multiple-excel-files-into-one-table/

 

Kind regards,
Viorel