Talend create boolean rows on condition in Tmap

Viewed 21

I have an Excel containing categories of company. In my dataset I want to add a boolean column telling if the categories is a start up or not. The column categorie is in string type.

Categorie
Bank
Manifacturing
Start Up
Start UP

The result I'm trying to obtain:

Categorie IsStartUp
Bank false
Manifacturing false
false
Start Up true
false
Start UP true

To this end I tried this formula in tmap: inputrow.Categorie!="Start Up"?false:true (I have put my column IsStartUp in boolean type).

But i have this error : java.lang.NullPointerException

What am I doing wrong ?

 https://i.stack.imgur.com/AdMGW.png

0 Answers
Related