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]

temp_Deal:

Load distinct dealgroup_id, supplier_id;

sql select dealgroup_id,supplier_id from temp_Deal;

inner join(temp_deal)

load distinct dealgroup_id;

sql select dealgroup_id from dealgroup;

the output is a table called temp_Deal;

[prma7799]

Like this??

temp_Deal:

Load

"dealgroup_id" as dealgroup_id ,

"supplier_id"

from  "temp_Deal" 

Join (temp_Deal)

temp_dealgroup:

Load

Distinct 

  dealer_id  ,

"dealgroup_id"  as dealgroup_id

from dealgroup

[suvechha_b]

"temp_Deal" is already a temp table . How to get it from temp table in qlikview ?

[suvechha_b]

Is this the correct script where temp table "temp_Dealgroup" where gets the distinct dealgroup_id with the dealer ?

"temp_Dealgroup":

inner join("temp_Deal")

Load dealgroup_id,

dealer;

SQL select dealgroup.id as dealgroup_id,

       dealgroup.institution_id as dealer

  from VAF5.dealgroup;

[prma7799]

if you don't want distinct id from "dealgroup" table then you can try your query

if possible share some sample data ...

[suvechha_b]

what to do if I want distinct dealgroup_id ?

[prma7799]

from which table you want distinct dealgroup_id ??

[suvechha_b]

From "temp_Deal" temp table .

[prma7799]

Try this

temp_Deal:

Load Distinct

"dealgroup_id" as dealgroup_id ,

"supplier_id"

from  "temp_Deal"

Inner Join (temp_Deal)

temp_dealgroup:

Load

  dealer_id  ,

"dealgroup_id"  as dealgroup_id

from dealgroup