Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Re: Combo with the fields in more than one Table

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

Not applicable

Re: Combo with the fields in more than one Table

Thanks Swuehl,

but unfortunetly not working.

Any other way ?

swuehl
Not applicable

Re: Combo with the fields in more than one Table

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

Re: Combo with the fields in more than one Table

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) ;