topic Re: Matching field value from another table in QlikView

Matching field value from another table

prat1507 — Wed, 25 Nov 2020 16:16:04 GMT

Lets say I have two tables as below;

Table1:

Col1

Table2:

Col2, Col3

A,10

A,20

B,30

The above two tables are not linked. Please don't make any changes. I want to show a straight table like below;

Col1 Sum.Col3

A 30

B 30

C 0

PabloTrevisan — Thu, 02 Aug 2018 20:41:05 GMT

Hi Pratyush,

execute with this script ..

table1:

LOAD * INLINE [

Col1

];

table2:

noconcatenate LOAD * INLINE[

Col2, Col3

A,10

A,20

B,30

];

MAP_Col:

Mapping LOAD Col2,

Sum(Col3)

resident table2

group by Col2;

Table:

LOAD Col1,

ApplyMap('MAP_Col',Col1,'0') as Col3

resident table1;

drop table table1;

drop table table2;

vishsaggi — Thu, 02 Aug 2018 20:52:40 GMT

Try this?

prat1507 — Fri, 03 Aug 2018 06:38:56 GMT

Hi, I already tried this yesterday night, tried this again today and it worked!! !! Thanks man!!