topic Re: Miss left join duplicated rows in QlikView

Miss left join duplicated rows

Mon, 26 Jan 2026 18:19:17 GMT

Hi Friends,

I am in a trouble in left join function.

my two sources and code as below pictures:

what Result I want to get is :

however, actual situation is only first row:

but when my sources change to:

everything goes well:

but in actual situation, I don't have AB2 in second table, what I can do to get the result I need?

Re: Miss left join duplicated rows

sushil353 — Mon, 29 Aug 2016 09:02:57 GMT

Hi,

Instead of left join why don't you use applymap ..

in your scenario you can write something like this

mapping load

list:

Name,Sex from xyz;

table:

load

Name

applymap('list',Name) as sex,

Category,

Date,

Amount

from aksdj;

HTH

Sushil

Re: Miss left join duplicated rows

agomes1971 — Mon, 29 Aug 2016 09:07:25 GMT

Hi,

test with this code

List:

LOAD * INLINE [

Name, Category, Date, Amount

AB1, A, 29/08/2016, 10

AB1, A, 30/08/2016, 11

AB1, A, 31/08/2016, 12

AB1, A, 01/09/2016, 13

AB1, A, 02/09/2016, 14

AB1, A, 03/09/2016, 15

AB1, A, 04/09/2016, 16

];

Left Join(List)

LOAD * INLINE [

Name, Sex

AB1, F

Ab2, F

];

HTH

André Gomes

Re: Miss left join duplicated rows

MindaugasBacius — Mon, 29 Aug 2016 09:11:59 GMT

I would use Applymap.

Like:

map_gender:

mapping load Name

,Sex

From Source;

List:

Load Name

,Category

,Date

,Amount

,Applymap('map_gender', Name, ':') as Sex

From Source

Give it a try - simple and efficient.

Re: Miss left join duplicated rows

sunny_talwar — Mon, 29 Aug 2016 10:26:38 GMT

Can you try this:

List:

LOAD Name,

Category,

Date,

Amount

FROM ...

Left Join (List)

LOAD Name,

Sex

FROM ...

List:

LOAD Name,

Category,

Date,

Amount

FROM ...

Right Join (List)

LOAD Name,

Sex

FROM ...

Re: Miss left join duplicated rows

Thu, 13 Jul 2017 02:52:25 GMT

thank you