Forum Discussion
import files based on file name in a folder
I have a large data set of various files all being placed in the same folder for example:
Bounces_20220703.csv
Bounces_20220704.csv
Bounces_20220705.csv
Clicks_20220703.csv
Clicks_20220704.csv
Clicks_20220705.csv
Opens_20220703.csv
Opens_20220704.csv
Opens_20220705.csv
The folder will have a new file for each every day with the current date format YYYYMMDD after the file name
What I want to do is have all of the clicks collated together, all the opens and all the bounces, and when a refresh happens it combines the latest daily output.
In Advanced Editor for Main Query, replace "C:\Test" with your path. Use the below pbix file to test.
6 Replies
- Vijay_A_Verma
Most Valuable Professional
Do you need 3 different outputs - one each for Bounces, Clicks, Opens OR a single output combining only 3 of these?
- Vijay_A_Verma
In Advanced Editor for Main Query, replace "C:\Test" with your path. Use the below pbix file to test.