topic Unifying tables in QlikView

Unifying tables

Fri, 22 Jul 2016 18:00:09 GMT

Hey, everyone!

I have an Issue:

I've 2 tables, like those:

I want to unify those tables, but, keeping the values from Table A and bring from Table B, only the continents which doesn't exists in Table A.

Sincerely, Luiz Bisco

oknotsen — Fri, 22 Jul 2016 18:06:56 GMT

Load both (naming the table TableA); they will auto concatenate since the fields have the same name.

Next, do this script:

TableEndresult:

noconcatenate

Load Continent,

sum(Value) as Value

resident TableA

group by Continent

;

drop table TableA;

sunny_talwar — Fri, 22 Jul 2016 18:07:40 GMT

May be using Where not Exist()

Table:

LOAD * INLINE [

Continent, Value

Europe, 100

South America, 150

North America, 92

];

Concatenate(Table)

LOAD * INLINE [

Continent, Value

Europe, 200

South America, 123

Central America, 200

Oceania, 105

]

Where not Exists(Continent);