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

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

datanibbler — Wed, 19 Nov 2014 14:04:27 GMT

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

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

Wed, 19 Nov 2014 14:08:41 GMT

Hi,

Load Recno(),

'Flag' as Flag

autogenarate 10;

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

datanibbler — Wed, 19 Nov 2014 14:42:55 GMT

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