topic Re: joining of table in QlikView

joining of table

Anonymous — Fri, 21 Apr 2017 08:45:15 GMT

I need to join one of my table with my master table ,

and den drop that table,how to proceed with it where exactly i shud write in script to join the table.

Re: joining of table

prma7799 — Fri, 21 Apr 2017 08:56:15 GMT

load *

MasterTable;

join (MasterTable)

load x,y

from abc;

Re: joining of table

satheshreddy — Fri, 21 Apr 2017 08:59:55 GMT

Hi DG,

just load first master table and load which one you need to join that table and in between tables you have to use join key word.

which table you want to drop?

Regards

Sathish

Re: joining of table

beckerv — Fri, 21 Apr 2017 09:02:01 GMT

Hi dynamic girl,

I assume that you want to keep all data of the master table and only join corresponding data from mytable?

Try this:

Master_table:

LOAD *

From xy;

mytable:

LEFT JOIN (Master_table) (otherwise use RIGHT/INNER/OUTER JOIN)

LOAD *

FROM ab;

DROP TABLE mytable; --> not necessary as mytable no longer exists after the join

You can join mytable from anywhere in the script - as long as the master table has already been loaded - and you have to define the table to join with in brackets --> LEFT JOIN (Master_table)

Best regards,

Viktoria

Re: joining of table

vinieme12 — Fri, 21 Apr 2017 11:06:31 GMT

Hi dynamic_girl‌

You have been very active on the community but I find it hard to believe there is not one thread that you have received an answer to!

Can you take some time to mark correct / useful response's to your posts for the benefit of other people who may have a similar query?

Read the below thread please.

Qlik Community Tip: Marking Replies as Correct or Helpful