Greetings...
I'm using FileList() to get all my tables in one folder, but there's some problem with my script because the store gives an error because it says the table doesn't exist.
my code here:
FOR Each file in FileList('..\1.Source Data\Excel\Consultório Extra 2\Consultório Extra 2 -' & '*' & '.xlsx')
DadosNovos2:
LOAD Data,
[Unidade de Negócio],
Consultório,
[Total Exames],
[Total Valor]
FROM
$(file)
(ooxml, embedded labels, table is Produção);
NEXT file