joining of table

[Anonymous]

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.

[prma7799]

load *

MasterTable;

join (MasterTable)

load x,y

from abc;

[satheshreddy]

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

[beckerv]

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

[vinieme12]

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