topic Re: How to load multiple files with same format using single load statement in QlikView

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

varunreddy — Mon, 13 Mar 2017 19:37:26 GMT

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

The syntax I am using:

FROM

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

Can anyone help me with the syntax?

Thanks,

Varun

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

maxgro — Mon, 13 Mar 2017 19:44:28 GMT

try with ?? for the month num

FROM

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

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

varunreddy — Mon, 13 Mar 2017 19:50:05 GMT

Hi Massimo,

Thanks for the quick response. I got below error.

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

varunreddy — Mon, 13 Mar 2017 19:56:34 GMT

Thanks Massimo!!

Cheers,

Varun