Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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;
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
"temp_Deal" is already a temp table . How to get it from temp table in qlikview ?
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;
if you don't want distinct id from "dealgroup" table then you can try your query
if possible share some sample data ...
what to do if I want distinct dealgroup_id ?
from which table you want distinct dealgroup_id ??
From "temp_Deal" temp table .
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