topic Link Table..Code in QlikView

Link Table..Code

Wed, 29 Jul 2009 19:20:28 GMT

Whats wrong in this code.. I am getting a error at JOIN (LINK_tabelle) LOAD DISTINCT

can anyone help me??


DL_AUFTRAGGEBER:
LOAD autonumber( DL_ID & FIRMA_ID & FIRMA_FB_KUERZEL & LEITER_NAME) as DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME;
SQL SELECT *
FROM DVG.DL_AUFTRAGGEBER;


LINK_tabelle:
Load distinct DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME
 resident DL_AUFTRAGGEBER;

 Drop Fields DL_ID, FIRMA_ID, FIRMA_FB_KUERZEL, LEITER_NAME FROM DL_AUFTRAGGEBER;

DL_AUFTRAGNEHMER:
LOAD autonumber( DL_ID & FIRMA_ID & FIRMA_FB_KUERZEL & LEITER_NAME) as DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME,
 VERANTWORTLICH;
SQL SELECT *
FROM DVG.DL_AUFTRAGNEHMER;

JOIN (LINK_tabelle) LOAD DISTINCT
DL_KEYAUFTRAG,
DL_ID,
FIRMA_ID,
FIRMA_FB_KUERZEL,
LEITERNAME
resident DL_AUFTRAGNEHMER;

DROP FIELDS DL_ID, FIRMA_ID, FIRMA_FB_KUERZEL, LEITERNAME FROM DL_AUFTRAGNEHMER;

Link Table..Code

Anonymous — Wed, 29 Jul 2009 19:27:37 GMT

LEITERNAME should be LEITER_NAME in your last resident load.

Link Table..Code

Wed, 29 Jul 2009 19:34:14 GMT

Thanks Jsomsen..I just copied it wrong..That is corrected but it does not help..Same Problem..

Link Table..Code

Wed, 29 Jul 2009 19:40:21 GMT

I think that QV, automaticly concatenate first two of your tables..

Link Table..Code

Wed, 29 Jul 2009 19:51:00 GMT

Thanks Vrbcic..I corrected that one also by adding noconcatenate but still it has a problem..It says keyfield DL_KEY_AUFTRAG not found


LINK_tabelle:
noconcatenate
Load distinct DL_KEY_AUFTRAG,
 DL_ID,
 FIRMA_ID,
 FIRMA_FB_KUERZEL,
 LEITER_NAME
 resident DL_AUFTRAGGEBER;

Link Table..Code

Wed, 29 Jul 2009 19:54:14 GMT

Done it. Sometimes small ", "or "_ "does irritate u..there was missing '_'

Thanks guys...