Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Combo with the fields in more than one Table

Hi Dear,

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

Table ATable B
CompanyItem Description
VVLCAM Description
Port
Item Description
Unit type

How to create this combo ?

4 Replies
swuehl
MVP
MVP

JOIN, MAP or LOOKUP your CAM Description to Table A.

Not applicable
Author

Thanks Swuehl,

but unfortunetly not working.

Any other way ?

swuehl
MVP
MVP

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?

Not applicable
Author

Try Like Below:

First create the Mapping Table for [CAM Description]

MAP_CAM:

Mapping

LOAD [Item Description] ,

          [CAM Description]

From SoureQVD.qvd (qvd) ;

ITEM_DETAILS:

LOAD Company,

          VVL,

          Port,

          [Item Description],

          [Unit type],

          [CAM Description],

          Company&'-'&VVL&'-'&Port&'-'& [CAM Description] &'-'&[Unit type] as First_Combo

;

LOAD Company,

          VVL,

          Port,

          [Item Description],

          [Unit type],

          ApplyMap('MAP_CAM',  [Item Description] ,'ND') AS [CAM Description]

FROM SOURECQVD1.qvd (qvd) ;