How to create Linktable / Keytable

Tue, 22 Sep 2009 18:54:27 GMT

Hello,

i found many posts and discussions about how to create linktables / keytables in QV. I am not very good in english, perhaps that is the reason why i d not understand how to create a linktable.
Here ist my structure:

Kundenstamm:
LOAD
st1_knr ,
st1_knr AS s_kundennr ,
st1_nam ;
SQL SELECT
*
FROM cdix.fyrst1;

Auftragskopf:
LOAD
kop_aufnr ,
kop_kunde ,
kop_kunde AS s_kundennr ,
kop_anl_datu ,
kop_anl_datu AS s_datum ;
SQL SELECT
*
FROM cdix.fakop;

Rechnungskopf:
LOAD
tfk_beleg ,
tfk_kunde ,
tfk_rechdat ,
tfk_rechdat AS s_datum ,
tfk_kunde AS s_kundennr ;
SQL SELECT
*
FROM cdix.fatfk;

Keytable:

?????????????

Thank you for your help

Best Regards

Peter Schmitt

topic How to create Linktable / Keytable in QlikView

How to create Linktable / Keytable