Sep 03 2019 06:43 AM
Hi all, First of all, I am new in this group-Somebody should welcome me!!! Otherwise, I'm seeking help on how to merge/combine over 3 files in power query editor. Whenever I get to the "get data from folder" option, the first file automatically gets selected(or sometimes I only have one option to select of all the 3 files), making difficult to combine all the files.
Please, I need your help.
Thanks.
Sep 03 2019 07:55 AM - edited Sep 03 2019 07:55 AM
Solution@Benze_ Welcome in this nuthouse!! :)
Once you have the preview of the list of files, make sure you click "Transform data". Then you should get a list of all files. Filter that list so you end up with exactly the files you want to combine.
Sep 03 2019 07:55 AM - edited Sep 03 2019 07:55 AM
Solution@Benze_ Welcome in this nuthouse!! :)
Once you have the preview of the list of files, make sure you click "Transform data". Then you should get a list of all files. Filter that list so you end up with exactly the files you want to combine.