topic Loading QVD data in QlikView

Loading QVD data

Marcio_Campestrini — Tue, 30 Dec 2014 10:38:51 GMT

Hi!

I'm with a question regarding load QVD data. I'm doing a partial reload (I'm reading 100 lines as script below) and, after loading two files, the total rows on target table (PedidoVenda) is 300 lines and not 200, as was expected.

Does anyone have an idea why?

Let $(vL.Ano) = Year(Today(1));

Let $(vL.Linha) = 100;

For i = $(vL.Ano) - 1 To $(vL.Ano)

PedidoVenda:

First $(vL.Linha)

Load * From $(vG.SharedQVDPath)PedidoVenda_$(i).qvd (qvd);

Next

Thanks in advance!

Re: Loading QVD data

MarcoWedel — Tue, 30 Dec 2014 23:55:25 GMT

Hi,

you could try:

Let vL.Ano = Year(Today(1));

Let vL.Linha = 100;

For i = $(vL.Ano) - 1 To $(vL.Ano)

PedidoVenda:

First $(vL.Linha)

Load * From $(vG.SharedQVDPath)PedidoVenda_$(i).qvd (qvd);

Next

hope this helps

regards

Marco