topic Re: Error in for loop in QlikView

Error in for loop

Tue, 25 Feb 2014 06:53:32 GMT

Hi All,

I am getting following Syntax error while fetching data by using For Loop.

My Syntax:

For Each vfilename in filelist ('Desktop\QV E books\Data\chk\*.csv')

Load *,

'$(vfilename)' As Filename

From[$(vfilename)];

Next vfilename

Plz find my error screen shot as attachment

-Jay

Sokkorn — Tue, 25 Feb 2014 06:59:13 GMT

Hi Jay,

How about this script

Load

FileName() As FileNames

From

Regards,

Sokkorn

sujeetsingh — Tue, 25 Feb 2014 07:00:06 GMT

This error points to the load you are using not the loop

Tue, 25 Feb 2014 07:03:55 GMT

Hi Dude,

Thank you for your reply. Your solution should work.But I need to test by using For...Next.

Thanks,

-Jay

Tue, 25 Feb 2014 07:05:18 GMT

Hi Sujeet,

Can you little bit more clear?What/Where I am missing

-Jay

jagan — Tue, 25 Feb 2014 07:43:30 GMT

Hi,

Try this

For each vFileName in Filelist ('C:\Path\*.txt')

Load *,

'$(vFileName)' as FileName

From [$(vFileName)];

Next vFileName

I think you have not give space after From in Load statement.

Regards,

Jagan.