topic Re: LOAD WITH LOOP in QlikView

LOAD WITH LOOP

Anonymous — Thu, 29 May 2014 14:06:15 GMT

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!

Re: LOAD WITH LOOP

Anonymous — Thu, 29 May 2014 14:19:52 GMT

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

Re: LOAD WITH LOOP

Gysbert_Wassenaar — Thu, 29 May 2014 14:22:09 GMT

Use single quotes:

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

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

(ooxml, embedded labels, table is Sheet1);

Re: LOAD WITH LOOP

Anonymous — Thu, 29 May 2014 14:44:38 GMT

Hi Vinay !

Thanks for writing, your answer helped me a lot.

Thanks again.

hugs.

Re: LOAD WITH LOOP

Anonymous — Thu, 29 May 2014 14:46:12 GMT

Hi Gysbert !

Thanks for helped me.

Now the script is working.

hugs.