load multiple .csv files to create a single data files

[0li5a3a]

Hi All,

I need an advise from an expert in loading multiple .csv files.

EX:

abc1.csv, abc2.csv, abc3.csv, abc4.csv ...........abc100.csv.

All good the same haeaders names.

I tried something like this:

let PathToDirectory = 'Z:\query38\*';

for Each File in FileList ('$(PathToDirectory)abc*.csv)' )

yourtable:

LOAD

*

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

NEXT File;

Kind regards,

[Anonymous]

anyone know how I can load multiple sheets from one excel, but all sheets have differente names and different data + tables? :s

[rwunderlich]

I suggest you start this question in a new thread.

-Rob

[0li5a3a]

maybe the below code can help you.

a, b, c, d... are tabs in an excel folder.

ex:

FOR EACH vSheet IN 'A','B','C','D'... etc

LOAD*

FROM

(ooxml, embedded labels, table is $(vSheet));

NEXT