Discussion Board for collaboration on QlikView Scripting.
I would like to ask for help. I have 3 tables that needs to be linked to each other.
LINEPRICE as LINEAMOUNT,
ENTRYID & '-' & DATE &'-'& BRANCHNAME as GNDLINEKEY,
ITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY
where VOIDED <> 1;
COMBOITEM &'-'& TXNNUMBER &'-'& BRANCHNAME as COMBOKEY
ENTRYID & '-' & date(floor(TRIM(DOB))) &'-'& TextBetween(FileBaseName(),'_','_') as GNDLINEKEY
I need to link table 2 and 3 without creating loops.
Thanks in advance,
Please any idea on this?
Just go with joins or concatenatio...whatever suits your requirement...
Just join them in another table and drop the both