LOAD WITH LOOP

[Anonymous]

Good day gentlemen!

It's been a few hours I'm trying to solve this problem, however I am unable to hold a LOOP, with 3 tables that I read.

I used the following command:

FOR Each v_maquina in "02","08","12"

Log:

LOAD [Hora Início],

     [Hora Fim],

     [Qtd. Horas],

     [Cod. Apontamento],

     [Desc. Apontamento],

     Turno,

     Operador,

     [Nro. Ordem],

     [Descrição OP],

     [Qtd. Produzida],

     [Desperdício Acerto],

     [Desperdício Virando],

     Atividade,

     Processo,

     Elemento,

     [Cod. Recurso],

     [Peso Médio (g)],

     Observações

FROM

(ooxml, embedded labels, table is Sheet1);

NEXT v_maquina

What is wrong with the command?

Please find attached the 3 tables, I'm trying to read.

I appreciate if someone can help me.

Thank you!

[Anonymous]

first of all remove quotes around the numbers...that should fix the issue. please see attached QVW file..

[Gysbert_Wassenaar · Accepted solution]

Use single quotes:

FOR Each v_maquina in '02','08','12'

load * FROM [LOG_K$(v_maquina).xlsx]

(ooxml, embedded labels, table is Sheet1);

next

[Anonymous]

Hi Vinay !

Thanks for writing, your answer helped me a lot.

Thanks again.

hugs.

[Anonymous]

Hi Gysbert !

Thanks for helped me.

Now the script is working.

hugs.