Discussion Board for collaboration on QlikView Scripting.
I have two table Table A and Table B, with primery key "Item Description".
I Need a combo in below manner.
Company&'-'&VVL&'-'&Port&'-'& [CAM Description] &'-'&Test_Unit_Type as First_Combo
How to create this combo ?
JOIN, MAP or LOOKUP your CAM Description to Table A.
but unfortunetly not working.
Any other way ?
One of these methods should work, as far as I see.
Could you post your relevant script snippet (what you already tried) and some lines of sample data?
Try Like Below:
First create the Mapping Table for [CAM Description]
LOAD [Item Description] ,
From SoureQVD.qvd (qvd) ;
Company&'-'&VVL&'-'&Port&'-'& [CAM Description] &'-'&[Unit type] as First_Combo
ApplyMap('MAP_CAM', [Item Description] ,'ND') AS [CAM Description]
FROM SOURECQVD1.qvd (qvd) ;