Forum Discussion
How to automatically refresh when file name is slightly different each time (timestamp at the end)
Import a FOLDER and 'Combine & Edit' to get to Power Query. On the 'Source' Step you should have a list of files in the Folder. While 'Source' is selected in Applied Steps, Add a Filter to the 'Name' column:
We are going to 'Filter' the File Names while on the 'Source' Step, to add a NEW Step removing the files we don't want...
Now a new 'Filtered Rows' step has appeared, and all following steps will not see the bad files.
Resident Rockstar
Import a FOLDER and 'Combine & Edit' to get to Power Query. On the 'Source' Step you should have a list of files in the Folder. While 'Source' is selected in Applied Steps, Add a Filter to the 'Name' column:
We are going to 'Filter' the File Names while on the 'Source' Step, to add a NEW Step removing the files we don't want...
Now a new 'Filtered Rows' step has appeared, and all following steps will not see the bad files.
Thank you for each one of you for contributing to this post! I got my data loads to work without any issues using the Import folder option and then using PowerQuery to filter the filename.
Appreciate all your time on this!!
-Jas.