Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Partner
Partner

Join, Left Join or Concatenate?

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

7 Replies
YoussefBelloum
Esteemed Contributor

Re: Join, Left Join or Concatenate?

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.

YB

Highlighted
momin_tahemas
Contributor

Re: Join, Left Join or Concatenate?

hi

You have to use JOIN

Because, you want all the Column of Both the tables

The Key will be Store

Regards

Tahemas Momin

Partner
Partner

Re: Join, Left Join or Concatenate?

Thank you

Re: Join, Left Join or Concatenate?

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


sahadevpatil
New Contributor III

Re: Join, Left Join or Concatenate?

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

Regards,

sahadev

Partner
Partner

Re: Join, Left Join or Concatenate?

Very nice article Will solve me tons of problems

Khan_Mohammed
Honored Contributor II

Re: Join, Left Join or Concatenate?

Left join

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