topic Re: left join not working properly in QlikView

left join not working properly

El_Davidus — Sat, 16 Nov 2024 01:09:30 GMT

I am trying to do a left join but it is not working as expected.

I have to tables , A and B. I am trying to left join them but the result, c, does not bring all the information it suposes to.

Does anyone know why ?

Table A :

Table B:

Table C:

Re: left join not working properly

Nikos — Fri, 28 Feb 2020 20:44:37 GMT

Hey David, Can you please share the statement you are running?
🙂

Just in case.. if you are doing a 2 table statement then running a join that could be at the base of the problem:
Case A

TableA:
Load
Field_1
From dataFile.Exts ...
;

TableC:
Load
Field_1
Resident TableA
;
left Join(TableC)
Load
Field_1,
Field_2
From dataFileB.Exts ...
;

the application will add a field "Field_2" to the TableA as you are loading DataFileB ...

To solve this try using the "NoConcatenate" option while running the creation of the table table "TableC"

/*** edited to match the table names on the question 🙂 ***/

Re: left join not working properly

El_Davidus — Fri, 28 Feb 2020 20:33:40 GMT

There is no table 3. Table C is the result of the left join .

left join(A)

Re: left join not working properly

Nikos — Fri, 28 Feb 2020 20:45:12 GMT

Sorry, just edited the example to match your question. 🙂

Re: left join not working properly

yassinemhadhbi — Fri, 28 Feb 2020 21:56:58 GMT

The fact that the field is string is bothering me ( even though that there's no probleme in it )

but to remove all the doubts how about using subfield : SubField(column, '|', 1), SubField(column, '|', 2) and the join based on these two columns

Re: left join not working properly

Brett_Bleess — Wed, 01 Apr 2020 16:34:22 GMT

If any of the posts got you what you needed, please be sure to close out the thread by using the Accept as Solution button on those posts, which will give the poster(s) credit for the help and let other Members know what worked. If you did something different, you can post that and then mark it.

Here is a Design Blog post on joining or not that might provide a bit more information on things for you:

https://community.qlik.com/t5/Qlik-Design-Blog/To-Join-or-not-to-Join/ba-p/1463102

Regards,
Brett