I have a table which has Address, city , Country and Unique IDs's
Sample raw data:
Since I have NULL value , i am getting 2 rows in qliksense table, one with proper address and the other with NULL.
I want to do, if Country is NULL, pick the values which is not null.
I tried the below expression in my load statement and I am not getting the desired result.
if(isnull(country), peek('country', -1), country) as COUNTRY.
I am sure this is a common problem and I am not how to fix this. Please help.
Thanks in advance!