Delta Load of Field Values from Table Names

[Anonymous]

Hi Guys,

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

Datum	Feld1	Feld2	Feld3
01.01.2014	a	b	c
20.12.2015	b	d	e
04.11.2013	c	f	g
15.03.2012	ooo	fff	ieee
12.03.2012	d	h	i
15.08.2016	e	j	o

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