topic Update row value(s) in resident table? in QlikView

Update row value(s) in resident table?

Thu, 09 Jun 2011 15:50:30 GMT

The attached image explains it all, I'm looking for the "cleanest" way to update a row in resident state from the same resident table. Basically I need to replace all null rows in one field with actual values from a different field (again both in the same resident table).

What comes to my mind is the lookup() funtion and join. I couldn't find any easy solution or function in the community but I'm thinking somebody has ran across this before.

Thanks for your ideas - DB

Update row value(s) in resident table?

Thu, 09 Jun 2011 16:57:45 GMT

Have you tried a simple if statement in the load script for the resident table?

if(column1 = '',column2,column1) as column1

Can also nest the if statements to have it scour all the columns for null values if needed.

Update row value(s) in resident table?

Thu, 09 Jun 2011 18:30:35 GMT

Leonard thanks for the simple solution! Implemented exactly what you posted, except used the isnull() function to find rows that = -1 (null)

Thanks!!