Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am new to Qlikview. A resident table is left joining with .csv file. one of the columns in resident table have null value. i need a query to show the null values in column to be mark as a "others" in the second column
before the resident load add:
NullAsValue YOUR_COLUMN; SET NullValue = 'others';
then try to join the csv.
Note that Nullasvalue and NullValue only works on Resident load!
regards
tim
perfect. glad i could help.
please mark the answer as accepted.
regards
tim
before the resident load add:
NullAsValue YOUR_COLUMN; SET NullValue = 'others';
then try to join the csv.
Note that Nullasvalue and NullValue only works on Resident load!
regards
tim
Thanks Tim. This helped to fix the issue
perfect. glad i could help.
please mark the answer as accepted.
regards
tim