topic Re: How to write script ? in QlikView

How to write script ?

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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,

Re: How to write script ?

ali_hijazi — Tue, 13 Feb 2018 10:53:51 GMT

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;

Re: How to write script ?

prma7799 — Tue, 13 Feb 2018 10:56:12 GMT

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

Re: How to write script ?

suvechha_b — Tue, 13 Feb 2018 11:00:38 GMT

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

Re: How to write script ?

suvechha_b — Tue, 13 Feb 2018 11:18:06 GMT

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;

Re: How to write script ?

prma7799 — Tue, 13 Feb 2018 11:22:24 GMT

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

if possible share some sample data ...

Re: How to write script ?

suvechha_b — Tue, 13 Feb 2018 11:23:45 GMT

what to do if I want distinct dealgroup_id ?

Re: How to write script ?

prma7799 — Tue, 13 Feb 2018 11:25:17 GMT

from which table you want distinct dealgroup_id ??

Re: How to write script ?

suvechha_b — Tue, 13 Feb 2018 11:26:08 GMT

From "temp_Deal" temp table .

Re: How to write script ?

prma7799 — Tue, 13 Feb 2018 11:29:15 GMT

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

Re: How to write script ?

ali_hijazi — Tue, 13 Feb 2018 12:59:38 GMT

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

load distinct column resident your_table;