topic Re: Append data on left join in QlikView

Append data on left join

userid128223 — Wed, 03 Oct 2018 19:04:52 GMT

How do you append data in following scenario while doing left join?

Sheet: Main

StudentName	Subject	Student#
John		123
Mike		223
Trout		455
Nancy		654
Karl	English	555

Sheet: Science

Student#	Subject	Grade
123	Science	55
223	Science	78
455	Math	67
654	Math	59

Re: Append data on left join

userid128223 — Wed, 03 Oct 2018 20:07:36 GMT

any ideas?

Re: Append data on left join

vishsaggi — Wed, 03 Oct 2018 20:12:09 GMT

Are you looking for this? If yes try below:

Main:

LOAD StudentName,

Subject,

Student#

FROM

[https://community.qlik.com/thread/315806]

(html, codepage is 1252, embedded labels, table is @1);

Left Join(Main)

LOAD Student#,

Subject AS Subject1,

Grade

FROM

[https://community.qlik.com/thread/315806]

(html, codepage is 1252, embedded labels, table is @2);

NoConcatenate

Science:

LOAD *,

IF(ISNULL(Subject1), Subject, Subject1) AS FinalSubject

Resident Main;

Drop Table Main;

Drop Fields Subject, Subject1;

Re: Append data on left join

userid128223 — Wed, 03 Oct 2018 20:19:18 GMT

Is this full proof. What if second table has nulls then what happens. Would it get wrong subject.

Re: Append data on left join

vishsaggi — Wed, 03 Oct 2018 20:35:08 GMT

So there is as possibility that you will have missing subjects in both the tables? So you will get Nulls if you have that for those subjects and it will display only Nulls for those matching Student# and subject.

Try like below:

IF(ISNULL(Subject1), Subject, Subject1)

IF this does not work can you send some data with that scenario and also your expected output.