topic Re: Add column to data table in QlikView

Add column to data table

Wed, 10 Dec 2014 09:32:23 GMT

hi all,

I have a table contains two columns

Size Length

1 2

in Script i want to add to this data table a column from another table: Department

Department

The result should be:

Department Size Length

A 1 2

B 1 2

how can I do that?

Thanks in advance

Re: Add column to data table

its_anandrjs — Wed, 10 Dec 2014 09:40:09 GMT

Hi,

Load Size, Length,1 as Dummy;

Load * inline [

Size, Length

1 , 2 ];

Join

Load Department,1 as Dummy;

Load * Inline [

Department

B ];

Regards

Anand

Re: Add column to data table

Wed, 10 Dec 2014 09:56:01 GMT

You can perform a join (INNER, LEFT, RIGHT).

The join is a Natural Join made over all the common Fields (where the field name is the same).

If your two tables do not share a common field as you above example you can use the JOIN prefix to get your desired result. See below

Table1:

LOAD * INLINE

[

Size, Length

1 , 2

]

;

JOIN

LOAD * INLINE

[

Field

]

;

Re: Add column to data table

Anonymous — Wed, 10 Dec 2014 10:12:48 GMT

hi Jacob,

Use applymap () by using if any matching column :

ProductMap:

Mapping Load

ProductID

ProductName

from Table1;

Table3:

Load

ApplyMap(' ProductMap ' ProductName ) as ProductID,

ProductName ,

ProductDescription

from Table2;

Regards

Neetha