Discussion Board for collaboration related to QlikView App Development.
Let vFile = '';
for each FoundFile in filelist( '.\txt\*.txt')
Let vFile = SubField(Text($(FoundFile)),'\txt\',2);
Why this variable does not work?
Table1:LoadSubField(‘$(FoundFile)’,'\txt\',2) as file,
I can't get this to work. I'm lost.
Go to Solution.
LOAD SubField('$(FoundFile)','\txt\',2) as file,
Your single quotes look like another type of quotes
How about simply doing?
Load FileName() as FileName From Table;
If you need your way, try this?
LET vCount = NoOfRows('$(FoundFile)');
Table1:LoadSubField($(FoundFile),'\txt\',2) as File