topic Re: left join in QlikView

left join

Anonymous — Mon, 15 Feb 2016 06:01:34 GMT

Hello Dear Programmers

I have to table like bellow

I want join FastHelper field with typeId but in fastHelper data entered like this(red oval) and seprate with "|" but in typeId the numbers are seprate each others.

So i will appreciate if anyone knows how can i join these two tables?

Re: left join

marcus_sommer — Mon, 15 Feb 2016 16:16:45 GMT

You could split your field fastHelper before with: subfield(fastHelper, '|') which caused a loop within the load for each delimited number and afterwards you could join your tables.

- Marcus

Re: left join

Colin-Albert — Mon, 15 Feb 2016 16:19:45 GMT

Consider using a mapping table and Applymap rather than a join. Don't join - use Applymap instead

This will also need the use of Subfield as Marcus_Sommer suggests.

Re: left join

maxgro — Tue, 16 Feb 2016 08:21:05 GMT

small example

dt:

Mapping LOAD * inline [

1, x

6750, aaa

6737, bbb

6000, ccc

6721, ddd

6747, eee

6731, fff

6730, ggg

];

fh:

load Id, FastHelper, ApplyMap('dt', NewFastHelper) as NewFastHelper;

load Id, FastHelper, SubField(FastHelper, '|') as NewFastHelper;

load * inline [

Id, FastHelper

1, 6750|6737|6000

2, 6721

3, 6747

4, 6731|6730

];

Re: left join

Anonymous — Wed, 17 Feb 2016 08:42:12 GMT

Thanks a lot. it worked