Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try with ?? for the month num
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
try with ?? for the month num
FROM
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);
Hi Massimo,
Thanks for the quick response. I got below error.
Thanks Massimo!!
Cheers,
Varun