Linking tables using condition

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

Dear all,

I have a table called OCRT which has a field U-Export.

If U-Export=Y

then the table OCRT has to be linked with the table OCRD by the link field Cardcode in both these tables.

then the OCRD table has to be linked to the table CQ-RTSM by the link fields U-ATBeatcode in OCRD with U-Routcode in CQ-RTSM

and

If U-Export=N

then the table OCRT has to be linked with the table OCRD by the link field Cardcode in both these tables.

then the OCRD table has to be linked to the table CQ-RTSM by the link fields U-Beatcode in OCRD with U-Routcode in CQ-RTSM

My expected output is

customername Beatname collection

aaa sandy 2300

aaa barany 1500

bbb reddy 2311

bbb selv 763

ccc askar 123

ddd Richy 5400

PFA for sample app.

Regards,

Joshua.

Re: Linking tables using condition

niclaz79 — Tue, 10 Apr 2018 14:09:44 GMT

Temp:

LOAD

cardcode,

[U-Export],

collection

FROM

[OCRT.xlsx] (ooxml, embedded labels, table is Sheet1);

Left Join(Temp)

LOAD

cardcode,

customername,

[U-ATBeatcode] as Routcode_at,

[U-Beatcode] as Routcode_beat

FROM

[OCRD.xlsx] (ooxml, embedded labels, table is Sheet1);

OCRDandOCRT:

NoConcatenate

LOAD

if([U-Export] = 'Y', Routcode_at, Routcode_beat) as %Link

Resident Temp;

drop table Temp;

CQRTSM:

LOAD

[U-Routcode] as %Link

FROM

[CQ-RTSM.xlsx]

(ooxml, embedded labels, table is Sheet1);

topic Re: Linking tables using condition in QlikView

Linking tables using condition

Re: Linking tables using condition