[resolved] tmap convert null to zero

One Star

[resolved] tmap convert null to zero

Hi all,
Hopefully a simple one for you. My output of a tmap join of two inputs returns the following:
.-----------------------+-----.
| tLogRow_1 |
|=----------------------+----=|
|Value |COUNT|
|=----------------------+----=|
|940 |847 |
|94106 |null |
|94107 |null |
|94_Source_Total |978 |
|950 |null |
|95106 |null |
|95107 |null |
|95_Source_Total |null |
|Grand_Total |978 |
'-----------------------+-----'

What i'd like to do, either in the tmap i'm using or in any subsequent components, is to convert the null values to "0". 
My java knowledge is close to non-existent so i'm a bit stuck with the tmap expression builder. Any help regarding how to handle this would be appreciated. 
Thanks!

Accepted Solutions
One Star

Re: [resolved] tmap convert null to zero

Use this expression in Tmap
row.COUNT==null?0:row.COUNT  

All Replies
One Star

Re: [resolved] tmap convert null to zero

Use this expression in Tmap
row.COUNT==null?0:row.COUNT  
One Star

Re: [resolved] tmap convert null to zero

Marvelous, thank you!