[resolved] tmap convert null to zero

Anonymous — Mon, 08 Sep 2014 16:47:23 GMT

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!

Re: [resolved] tmap convert null to zero

Anonymous — Mon, 08 Sep 2014 17:03:33 GMT

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

Re: [resolved] tmap convert null to zero

Anonymous — Mon, 08 Sep 2014 17:07:25 GMT

Marvelous, thank you!

topic Re: [resolved] tmap convert null to zero in Talend Studio

[resolved] tmap convert null to zero

Re: [resolved] tmap convert null to zero

Re: [resolved] tmap convert null to zero