Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Valued Contributor

Loading QVD data

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!

Márcio Rodrigo Campestrini
1 Reply
Highlighted

Re: Loading QVD data

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