Discussion Board for collaboration on QlikView Scripting.
I have the above type of loop to load all files in a given directory.
The issue is, I need the contents of the files plus some metadata that I can get out of the filenames.
=> I have to LOADs, one with maybe 10 lines, one with only 1
=> How can I generate a dummy_field on which to join those (I want the metadata in each one of those 10 lines)
I have read that IterNo() is only good to use in a WHILE_loop - so what can I use here?
Thanks a lot!
'Flag' as Flag
I've made it now. I realized I needed some iteration-specific field on which to join those two parts - and at the same time keep the output from the different iterations separate from each other.
=> So I took a little detour and created a small auxiliary table with the filenames that I can count through in a >> For ... NEXT << loop - so I have a counter_variable.
Thanks a lot anyway!