topic Re: Combo with the fields in more than one Table in QlikView

Combo with the fields in more than one Table

Fri, 20 Dec 2013 10:22:34 GMT

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

How to create this combo ?

swuehl — Fri, 20 Dec 2013 10:27:52 GMT

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

Fri, 20 Dec 2013 11:03:44 GMT

Thanks Swuehl,

but unfortunetly not working.

Any other way ?

swuehl — Fri, 20 Dec 2013 11:07:45 GMT

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?

Fri, 20 Dec 2013 14:50:47 GMT

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