Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
random_user_3869
Partner - Creator III
Partner - Creator III

loading multiple csv files issue

Hello i do the following statement,

for each vs_file in FileList('$(vL.DirectoryPath)*.csv')
Temp_Table:
LOAD
*
FROM [$(vs_file)]
(txt, utf8, embedded labels, delimiter is ',', msq, header is 11 lines);


next vs_file

I have a script error saying that the file has not been found.

anyone can help ?

Thanks

 

Labels (1)
11 Replies
Adinaa
Partner - Contributor
Partner - Contributor

Hello,

 

I have the same problem.

Did you find the solution to this issue?

 

Thanks!

random_user_3869
Partner - Creator III
Partner - Creator III
Author

Hello @Adinaa ,

Do your csv files have the same structure (same field, column, headers at the same row level) ?

I think that the error regarding my issue was 

 

FROM [$(vs_file)]
(txt, utf8, embedded labels, delimiter is ',', msq, header is 11 lines);

The header for the csv files were not the same and as a consequence the statement could not work.