left join Substitute - Page 2 - Qlik Community

Report Inappropriate Content · ‎2014-09-15

Is there is any substitute of left join for the table having more than one fields

Report Inappropriate Content · ‎2014-09-16

But in that case one table should have only two fiel which is to b e used in mapping load

ashfaq_haseeb · ‎2014-09-16

Like this,

have a look at attach application.

if it answer, make sure to close this thread.

Regards

ASHFAQ

Report Inappropriate Content · ‎2014-09-16

No it won't work, if i Want to add ID it generate a result which is equivalent to right join

ashfaq_haseeb · ‎2014-09-16

I gave you working example without join.

You could say applymap is replacement of join.

Regards

ASHFAQ

deepakqlikview_123 · ‎2014-09-16

Hi Ashfaq,

Sorry but can you please tell me 1 thing,

Apply map is work as look up ref table.

Left join can give all records from first table with matching rec in second table.

Then how could be applymap will be replacement for left join.

Thanks,

Deepak

Report Inappropriate Content · ‎2014-09-16

It won't work as a replacement of left join in all the scenario

ashfaq_haseeb · ‎2014-09-16

Hi Deepak,

I have implemented both Left Join and apply map in this post you can a look at once.

To clear concepts I would suggest you to go through this article from Henric.

Regards

ASHFAQ

deepakqlikview_123 · ‎2014-09-16

Thanks Ashfaq

That is helpful for me.