Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

tmap catch nulls

Hello

 

I am trying build a job where a list of attributes are loaded from a csv file and for each loaded row a tMap component catch the nulls and change it for a different value. row3 to output1

 

I am only able to do it in String, can you help me finding the function for:

- Integer

- Floats

-Doubles

 

Labels (3)
3 Replies
vapukov
Master II
Master II

generally, the same construction must work for all 3 types (Integer, double, float)

 

Integer is possible to compare with null, Int not

Anonymous
Not applicable
Author

i was only able to create the function to strings which doesn´t work for any kind of those

Anonymous
Not applicable
Author

Generally, if you input a csv file, which the row is in integer or double or long type. The NULL value often default is 0 in row so the easiest way just compare if it's > 0.


Screenshot from 2018-11-21 11-56-04.png