topic Re: 2 tables same field name in QlikView

2 tables same field name

JACKNIEKERK — Wed, 25 Nov 2020 16:16:04 GMT

2 tables with same keyname ARTNR

LOAD ARTNR,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

This generates a $Syn1 table

creating a grafic object will say all expressions deactivated

i need a connection by pickinng ARTNR form STAMMARTIKEL; and show all records in umsatzPOS with that ARTNR

Re: 2 tables same field name

Kushal_Chawda — Sat, 18 Jan 2020 12:47:05 GMT

If I understood correctly, basically you need a join of two table here

Data: LOAD ARTNR, ARTID, ARTBEZ, ARTEINHEIT, VERGLEICHT, TEXTID0, TEXTID1, TEXTID2, TEXTID3, TEXTID4; SQL SELECT * FROM STAMMARTIKEL; left join(Data) LOAD ARTNR, MENGEKG, PREISLV, PREISGV, PREISEKES, PREISLVES, VORGDATUM; SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

Re: 2 tables same field name

JACKNIEKERK — Sat, 18 Jan 2020 15:01:35 GMT

true, only changed the algoritme order to upper line due to reading all sales form data

Items:
left join(Data)
LOAD ARTNR,
ARTID,
ARTBEZ,
ARTEINHEIT,
VERGLEICHT,
TEXTID0,
TEXTID1,
TEXTID2,
TEXTID3,
TEXTID4;
SQL SELECT * FROM STAMMARTIKEL;

Data:
LOAD ARTNR,
ARTBEZ as plubez,
MENGEKG,
PREISLV,
PREISGV,
PREISEKES,
PREISLVES,
VORGDATUM;
SQL SELECT * FROM umsatzPOS where VORGDATUM = '12-5-2019';

Re: 2 tables same field name

JACKNIEKERK — Sat, 18 Jan 2020 15:02:49 GMT

thanks for help, regards Jack