topic Creating Tables from Resident Load (treating null values) in QlikView

Creating Tables from Resident Load (treating null values)

darrellbutler — Wed, 16 May 2012 16:08:37 GMT

Hi,

I am creating a table by doing a right join from a resident table onto a table created by a data extract from an oracle table. This works fine but as a result of this join I have some null values that i want to replace with zero.

I tried to address this by doing another resident load based on the table created in the previous step then applying a simple if(isnull() formula to populate nulls with zero. However the 2nd resident load is completely ignored - is there any reason for this ? can you do a resident load from a table also partly created from a resident load ?

Many thanks

Creating Tables from Resident Load (treating null values)

vgutkovsky — Wed, 16 May 2012 16:44:35 GMT

My guess is that the reason it appears to be ignored is your field names in the 2nd load are identical to those in the table that resulted from the join. In such a situation, QlikVIew will attempt to autoconcatenate the tables together. You can break away from this default behavior by adding NOCONCATENATE before your 2nd resident load.

Regards,

Vlad

Creating Tables from Resident Load (treating null values)

darrellbutler — Wed, 16 May 2012 21:07:43 GMT

Thankyou Vlad, an educated guess !