I am trying to load all files within the folders. Currently my script is working just fine. I just realized I can't keep my script written like that because as year go by more folders will be added. I just can't figure out how to write a script that grabs all the files from the folder that works with the script I have above. This is my folder structure and I am trying to grab all the files with the 2014 and 2015 folders. I appreciate the reply.
- Mar .xlsx
Have you thought of using another For loop before your current loop, something like this may be
Let vYear = Year(Today());
For i = 2014 to $(vYear)
FOR EACH vSheet IN 'Alpharetta','Duluth','Chicago','DC','Philly'
[In/Out Pool Indicator],
[Payout - Attend],
[Payout - Defects],
,'$(vSheet)' as Source,
FileName() as FileName
(ooxml, embedded labels, header is 3 lines, table is $(vSheet));
.... and so on
I am not sure what other delicacies are there, but something like should work?
Massimo thanks for the reply! I tried everyone's method but yours was the only one that worked for me however, it created two more tables in my table model. I am still sort of new to qlikview but I do know synthetic keys are bad. Is there a way to get rid of them? I have attached my table model. Thanks for helping me out everyone! I really do appreciate it!!