replace null value by '.'

[Anonymous]

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]

Using Ternary operator in tMap we can achieve this ,

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

[Anonymous]

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

[ashif2 · Accepted solution]

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]

[Vinlogs]

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

[Anonymous]

it's working properly...

Thank you so much..