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

[arngue]

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 · Accepted solution]

Try this

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

Your single quotes look like another type of quotes

[Anil_Babu_Samineni]

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);