tmap update output string if input string is null

Five Stars

tmap update output string if input string is null

Hey folks,

 

Please see pic attached. I am trying to catch if an input string is null if so I want to replace it with "Unknown" in the output row. I have tried several different ways but can't get it working any help is appreciated. 

 

Neil. 

 

Tmap Null.jpg


Accepted Solutions
Highlighted
Thirteen Stars

Re: tmap update output string if input string is null

hi Neil,

 

as described it must be 

 

row5.Aligment==null?"Unknown":row5.Aligment

condition?true:false

 

in your case if null it continue to be null, and replace all not null

-----------

All Replies
Highlighted
Thirteen Stars

Re: tmap update output string if input string is null

hi Neil,

 

as described it must be 

 

row5.Aligment==null?"Unknown":row5.Aligment

condition?true:false

 

in your case if null it continue to be null, and replace all not null

-----------
Five Stars

Re: tmap update output string if input string is null

Thanks very much worked perfectly!

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.