Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Importing multiple files into a single table

I have a directory with 15 or so CSV files that all have the exact same field names and structure.  When I use the code:

CLReviewData:

LOAD * FROM directory\*.csv (txt, codepage is 1253, embedded labels, delimiter is ',', msq);

It works for most of the tables, but it doesn't work for 2 of the files.  Instead, it will import them into CLReviewData-1 and CLReviewData-2. 

Any thoughts on what can be causing that?

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

I found it --- annoying type mismatch where some of the files had year as a number and some had it stored as text.

View solution in original post

1 Reply
Anonymous
Not applicable
Author

I found it --- annoying type mismatch where some of the files had year as a number and some had it stored as text.