Discussion Board for collaboration on QlikView Scripting.
Somebody please help me on this:
I have a table in Load script like this.
Left Join (FACT)
WHERE Exists (MyId, MyId);
Since it is a left join, I need to update the Z = Y if it is NULL. How can I do this???
Go to Solution.
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;
load MyID, X, Y, //Other columns
if(isnull(Z),Y,Z) as Z
Drop table TEMP_Fact;
It works~~~ thank you so much!!!!
Try like this
Left Join (FACT_Temp)
Z AS Ztemp,
If(IsNull(Z), Y, Z) AS Z,
DROP TABLE FACT_Temp;
Hope this helps you.