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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.