Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
anyone know how I can load multiple sheets from one excel, but all sheets have differente names and different data + tables? :s
I suggest you start this question in a new thread.
-Rob
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