topic Insert calculated field from resident table in QlikView

Insert calculated field from resident table

cbaqir — Sat, 16 Nov 2024 17:57:36 GMT

I need to add the GOVERNING_GROUP field from my fact table called EHRG_TICKET into the RPT_EHRG_BUILD_HOURS table.

RPT_EHRG_BUILD_HOURS:
LOAD "bug_id" as DEFECT_ID,
"build_group",
monthstart(month) as month,
"pte_design",
"pte_build",
analyst,
"actual_design",
"est_np_build",
"act_np_build",
"est_prod_build",
"act_prod_build",
"ETL_DATE";
SQL SELECT *
FROM "IT_DW".dbo."RPT_EHRG_BUILD_HOURS";

GOVDATA:

LOAD DEFECT_ID,GOVERNING_GROUP
Resident EHRG_TICKET;

Inner Join (GOVDATA) Load GOVERNING_GROUP Resident RPT_EHRG_BUILD_HOURS;

drop table GOVDATA;

Re: Insert calculated field from resident table

dplr-rn — Fri, 16 Oct 2020 19:34:47 GMT

why do you want to add it to the table ?as the 2 tables are linked you get GOVERNING_GROUP in front end anyway

in any case

during the join you dont have the key and you seem to have done it other way round. you code tries to update GOVDATA table and then drops it

going by your description where you say you want to add governing_group in to RPT_EHRG_BUILD_HOUR table try something like below (inner join or left depends on the data)

Inner Join (RPT_EHRG_BUILD_HOURS)

LOAD DEFECT_ID,GOVERNING_GROUP
Resident EHRG_TICKET;

let me know if i missed something

Re: Insert calculated field from resident table

cbaqir — Fri, 16 Oct 2020 19:50:41 GMT

I need to join the build hours table to another table with a concatenated key of month and Governing Group.

Re: Insert calculated field from resident table

cbaqir — Fri, 16 Oct 2020 20:17:40 GMT

I am still getting a synthetic table.

How would I then be able to create my key [Governing Group]&'-'&monthstart(month) as %GG_MONTH_KEY?

Re: Insert calculated field from resident table

dplr-rn — Mon, 19 Oct 2020 20:57:49 GMT

i dont understand you need well enough to answer fully. (initial question didnt have anything on month)

but if you are adding GOVERNING_GROUP to RPT_EHRG_BUILD_HOURS purely to join another table.

you could delete the column from RPT_EHRG_BUILD_HOURS after you have done the join (i am assuming you have done so in picture the last post)

that should address the synthetic key i see in the picture (last one)