looping through folder file

[Anonymous]

Dear all,

is it possible to loop through a folder and choose only the tables with a certain prefix name ?

for example, I would consider only the table with BUFFER_ as prefix name

Help please !1

Thanks in advance

[its_anandrjs · Accepted solution]

Load your script some thing like in location type like this BUFFER_*.xlsx if file name start with this only. By this all your tables load and concatenate with each other and make single table also if field name are same.

LOAD FieldName,

  FileBaseName() as FileName 

FROM

(ooxml, embedded labels, table is Sheet1);

Hope this helps

Thanks & Regards

[maxgro]

Directory;

FOR Each File in filelist ('.\BUFFER_*.xlsx')

  LOAD *

  FROM

  '$(File)'

  (ooxml, no labels, table is Sheet1);

NEXT File;

or

Directory;

LOAD *

FROM

BUFFER_*.xlsx

(ooxml, no labels, table is Sheet1);

[Anonymous]

Thanks very much!!

[Anonymous]

Thanks very much for your help