Delta Load of Field Values from Table Names

Anonymous — Fri, 27 Oct 2017 13:26:41 GMT

Hi Guys,

i want to use Delta Load to generate the QVDs of each year from Table. e.g:

That is my code, but i got only the values from 2012.

I want to have 4 QVDs; KG2012.qvd, KG2013.qvd, KG2014.qvd, KG2015.qvd, KG2016.qvd

Delta:

LOAD Datum,

Year(Datum) as Jahr,

Feld1,

Feld2,

Feld3

FROM

Delaload.xlsx

(ooxml, embedded labels, table is Tabelle1);

Min_Max_Jahr:

LOAD

Max(Jahr) as MaxJahr,

Min(Jahr) as MinJahr

Resident Delta;

Let MaxJahr = Peek('MaxJahr', -1);

Let MinJahr = Peek('MinJahr', -1);

For i = 1 to (NoOfRows('Delta')-1);

NoConcatenate

KG:

LOAD

Datum,

Jahr,

Feld1,

Feld2,

Feld3

Resident Delta where Jahr = $(vJahr);

Let vJahr = Peek('Jahr', -1,'KG');

Store KG INTO '$(vQVD)\Delta$(vJahr)'.qvd;

Next i;

Drop Table Delta;

Thank in advance

topic Delta Load of Field Values from Table Names in QlikView