Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
datanibbler
Esteemed Contributor

Joining in a >> For Each File in Filelist() << loop

Hi,

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!

Best regards,

DataNibbler

2 Replies
Not applicable

Re: Joining in a >> For Each File in Filelist() << loop

Hi,

Load Recno(),

         'Flag' as Flag

autogenarate 10;

datanibbler
Esteemed Contributor

Re: Joining in a >> For Each File in Filelist() << loop

Hi rakesh,

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!

Best regards,

DataNibbler

Community Browser