topic Re: Update Values in Resident table in QlikView

Update Values in Resident table

Thu, 26 Sep 2013 09:00:48 GMT

Somebody please help me on this:

I have a table in Load script like this.

FACT:

Load MyId,

SQL xxxxxxxx;

Left Join (FACT)

Load MyId,

//Append Columns

WHERE Exists (MyId, MyId);

SQL xxxxxxx;

Since it is a left join, I need to update the Z = Y if it is NULL. How can I do this???

Re: Update Values in Resident table

Fri, 27 Sep 2013 03:30:50 GMT

please help~~~

Re: Update Values in Resident table

manas_bn — Fri, 27 Sep 2013 04:16:25 GMT

Hi Sharon,

I am not sure if this is the right method with regard to performance, may be someone more experienced can help, but you can try the following:

After the Left join is done,

Rename Table Fact to TEMP_Fact;

Fact:

Noconcatenate

load MyID, X, Y, //Other columns

if(isnull(Z),Y,Z) as Z

Resident TEMP_Fact;

Drop table TEMP_Fact;

Cheers!

Manas

Re: Update Values in Resident table

Fri, 27 Sep 2013 05:05:06 GMT

It works~~~ thank you so much!!!!

Re: Update Values in Resident table

jagan — Fri, 27 Sep 2013 05:14:31 GMT

Hi,

Try like this

FACT_Temp:

Load MyId,

SQL xxxxxxxx;

Left Join (FACT_Temp)

Load MyId,

//Append Columns

SQL xxxxxxx;

FACT:

LOAD

MyId,

Z AS Ztemp,

If(IsNull(Z), Y, Z) AS Z,

RESIDENT FACT_Temp;

DROP TABLE FACT_Temp;

Hope this helps you.

Regards,

Jagan.