topic Re: Join, Left Join or Concatenate? in QlikView

Join, Left Join or Concatenate?

brunopaulo — Wed, 25 Nov 2020 16:16:04 GMT

Hello community,

I have a table with 2 columns (Store and address) and another one with Store, profit, costs and nr of sales.

So i want join them where i get a single table with store, address profit costs and nr of sails. What command should i use? And please explain me why because i did try use all of them and isnt working.

Thanks in advance.
Best Regards

Bruno Paulo

Re: Join, Left Join or Concatenate?

YoussefBelloum — Fri, 06 Oct 2017 09:07:47 GMT

Hi,

You should use a Join, because you want to join 2 table with a key field (Store).

Now you should know what do you want on the final table: the lines of the (Stores) present on the 1st table or the lines of the (Stores) present on the second table.

I suggest you to try the join, the left join, the right join and see the result of the final table for each reload, you will know which type of join you need.

Re: Join, Left Join or Concatenate?

Anonymous — Fri, 06 Oct 2017 09:16:53 GMT

You have to use JOIN

Because, you want all the Column of Both the tables

The Key will be Store

Regards

Tahemas Momin

Re: Join, Left Join or Concatenate?

brunopaulo — Fri, 06 Oct 2017 09:32:56 GMT

Thank you

Re: Join, Left Join or Concatenate?

Colin-Albert — Fri, 06 Oct 2017 10:37:44 GMT

I would use Applymap to add the address field to the table with Store, profit, costs and nr of sales.

Applymap is a safer option as it will always give a 1:1 match and cannot cause duplicate rows..

Don't join - use Applymap instead

Re: Join, Left Join or Concatenate?

Anonymous — Fri, 06 Oct 2017 10:42:25 GMT

you can use "join" to make one table base on Key but if dont have key with others table then use 'Concatenation'

Regards,

sahadev

Re: Join, Left Join or Concatenate?

brunopaulo — Fri, 06 Oct 2017 14:16:20 GMT

Very nice article Will solve me tons of problems

Re: Join, Left Join or Concatenate?

MK9885 — Fri, 06 Oct 2017 16:56:27 GMT

Left join

and use the Key between those tables to map it correctly.