How to load common values from same column from different table

[qliklearnervir]

Hi,

I have 2 different table where i wan to load entire data from both the table for one of the column:

Act:

Property_id,

Segment

From Act.qvd;

Bud:

Property_id,

Segment

From Bud.qvd;

there are Segment field in both table and soem of the segment values are present in Act and some of the values are present in Bud.

i want to load the table like all the values should available in segment column and i can use this column as dimension in chart.

please suggest

[kakani87]

Can you post some sample data ...

[sasiparupudi1]

MAP_Bud:

Mapping load Property_id,

Segment

From Bud.qvd;

Act:

Property_id,

If (len (trim (Segment))=0,applymap ('MAP_Bud',Property_id,'NA') as Segment

From Act.qvd;

[Anonymous]

ty this is Concatenate...

Act:

Property_id,

Segment,

Value

From Act.qvd;

concatenate (Act)

Bud:

Property_id,

Segment

Value

From Bud.qvd;

Result:

Load Property_id,

        Segment,

        sum(Value)  as New_Value

resident Act group by Property_id, Segment;

drop table Bud;