topic Re: How to load common values from same column from different table in QlikView

How to load common values from same column from different table

qliklearnervir — Sat, 24 Mar 2018 10:18:56 GMT

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 — Sat, 24 Mar 2018 10:40:07 GMT

Can you post some sample data ...

sasiparupudi1 — Sat, 24 Mar 2018 11:24:18 GMT

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 — Sat, 24 Mar 2018 11:50:06 GMT

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;