Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I'm loading several excel files with diferente fields. I want to create a condition that replace null values for 0.
I know how to do for a specifc field but in this case the name of field can be variable (more then 100 fields) so i want create a condtion for table.
Check Table if null replace to 0.
Anyone has idea how to do it? Thanks in advance
Regards
you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.
SET NullInterpret = ‘’;
regards
tim
Try this code above your load script.
NullAsValue *; SET NullValue = ‘0’;
regards
tim
Didnt work. But this is the way
you can try to add this line. Maybe QlikView dont recognize that the empty cells are real NULL Values.
SET NullInterpret = ‘’;
regards
tim
Thank you, solved it!!!!