topic Re: replace null value by '.' in Talend Studio

replace null value by '.'

Anonymous — Wed, 04 Oct 2017 12:26:39 GMT

Hello,

I have one colomn for contact number some user did not enter value in that column...

Now i want to replace that value ny DOT '' . ''

Please reply

Thanks

ashif2 — Wed, 04 Oct 2017 12:33:56 GMT

Using Ternary operator in tMap we can achieve this ,

row1.ColumnName==null || row1.ColumnName.isEmpty()?".":row1.ColumnName

Anonymous — Wed, 04 Oct 2017 13:25:27 GMT

this making new column ...and i want "." where column value is null

ashif2 — Wed, 04 Oct 2017 13:28:53 GMT

No need to new column, you can change the simple expression in tMap Output

i.e. row1.ColumnName to

row1.ColumnName==null || row1.ColumnName.isEmpty()?".":row1.ColumnName

Anonymous — Wed, 04 Oct 2017 13:28:53 GMT

Vinlogs — Wed, 04 Oct 2017 14:23:48 GMT

I believe ashifa is right, try his expression in tmap and see if that helps!

Anonymous — Thu, 05 Oct 2017 07:40:13 GMT

it's working properly...

Thank you so much..