Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
MCampestrini
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

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

Community Browser