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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Edith1
Creator
Creator

tHMap how to exclude blank values for if then statement

Is there a way to exclude blanks or nulls after using an if then statement in Data Mapper?

Here's the tHMap - I'm using the if then statement for output field Type, but since there's more types, they're being written as blanks or nulls. How do I exclude values I don't want? 

0683p000009MabZ.png

 

 

 

 

 

 

 

 

 

Here's the result of the test run. I don't want to write out the Type with blanks or nulls (highlighted fields on screenshot below). Is there a way to map an if then statement and then check if that same field has a value?   

0683p000009Mabe.png

 

 

Labels (3)
4 Replies
manodwhb
Champion II
Champion II

You can exclude null values,for the blanks you need to convert blank to null.

manodwhb
Champion II
Champion II

You can exclude null values,for the blanks you need to convert blank to null.

Edith1
Creator
Creator
Author

How would I remove null rows?  The mapper is writing the output as an array for that one column. 

Edith1
Creator
Creator
Author

How would I remove null rows?  The mapper is writing the output as an array for that one column.