Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have 2 files in my folder X
Datafile2022Q4.xls
Datafiles2023Q1.xls
Soo for every quarter end one file wil l be added to my X folder.so in July month Q2 file will be added to that folder
Soo for July month I have 3 files in folder
Datafile2022Q4.xls
Datafiles2023Q1.xls
Datafile2023Q2.xls
Soo every quarter we will have another fie
How can I load these files dynamically without changing my code every quarter
There are some Qlik functions that can help here and depending on what you need to extract from the filename to supplement the data in your tables.
You can use a loop to iterate through each file and the data from each file should be concatenated together into one table automatically.
Here is an example that might work for you: