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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
varunreddy
Creator III
Creator III

How to load multiple files with same format using single load statement

Hi All,

I have files coming in same format every month in the excel files. I am trying to load them using single load statement. I came to know about the function "\*." .

My files names are:

GCDS_Individual_02_17.csv

GCDS_Individual_02_17.csv

The syntax I am using:

FROM

(
txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Can anyone help me with the syntax?

Thanks,

Varun

1 Solution

Accepted Solutions
maxgro
MVP
MVP

try with ?? for the month num

FROM

(
txt, codepage is 1252, embedded labels, delimiter is ',', msq);

View solution in original post

3 Replies
maxgro
MVP
MVP

try with ?? for the month num

FROM

(
txt, codepage is 1252, embedded labels, delimiter is ',', msq);

varunreddy
Creator III
Creator III
Author

Hi Massimo,

Thanks for the quick response. I got below error.

varunreddy
Creator III
Creator III
Author

Thanks Massimo!!

Cheers,

Varun