topic Re: How to load filename as a column inside for loop in load script in QlikView

How to load filename as a column inside for loop in load script

arngue — Sat, 16 Nov 2024 03:47:15 GMT

Let vFile = '';

for each FoundFile in filelist( '.\txt\*.txt')

Let vFile = SubField(Text($(FoundFile)),'\txt\',2);

Table1:
Load
$(vFile)

Why this variable does not work?

for each FoundFile in filelist( '.\txt\*.txt')

Table1:
Load
SubField(‘$(FoundFile)’,'\txt\',2) as file,

I can't get this to work. I'm lost.

sunny_talwar — Tue, 23 Apr 2019 13:24:22 GMT

Try this

Table1:
LOAD SubField('$(FoundFile)','\txt\',2) as file,

Your single quotes look like another type of quotes

Anil_Babu_Samineni — Tue, 23 Apr 2019 13:28:36 GMT

How about simply doing?

Load FileName() as FileName From Table;

If you need your way, try this?

Let vFile = '';

for each FoundFile in filelist( '.\txt\*.txt')

LET vCount = NoOfRows('$(FoundFile)');

Table1:
Load
SubField($(FoundFile),'\txt\',2) as File

Autogenerate $(vCount);