Discussion Board for collaboration related to QlikView App Development.
I have a table called OCRT which has a field U-Export.
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
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.
[OCRT.xlsx] (ooxml, embedded labels, table is Sheet1);
[U-ATBeatcode] as Routcode_at,
[U-Beatcode] as Routcode_beat
[OCRD.xlsx] (ooxml, embedded labels, table is Sheet1);
if([U-Export] = 'Y', Routcode_at, Routcode_beat) as %Link
drop table Temp;
[U-Routcode] as %Link
(ooxml, embedded labels, table is Sheet1);