How to write script ?

[suvechha_b]

HI All ,

I got a Table object say "temp_Deal" which got "dealgroup_id" , "supplier_id"

I need to create a temp table say "temp_dealgroup"  . Please assist how to write the script -

In the temp table , I need distinct "dealgroup_id" with dealer_id from database table "dealgroup" join with "temp_Deal" with dealgroup_id as common.

Thanks,

[ali_hijazi]

if the table is already in Qlik then to read from it you use RESIDENT

load distinct column resident your_table;