[resolved] tmap convert null to zero

[Anonymous]

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!

[Anonymous · Accepted solution]

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

[Anonymous]

Marvelous, thank you!