Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

convert string datatype to boolean datatype

Hello,
I have requirement where i have to convert a string coming from a database to a boolean datatype in to salesforce.
the  string value are ( 'Y' and 'N' ) from a column in table.....
and my mapping components are 
sql server table--->tmap-->salesforce output component...
which method should i use in tmap expression editor to convert the string 'N' or string 'Y' to boolean datatype for salesforce.
or this needs to be converted by using something else???im new to talend so pls provde the answer in detail
Labels (3)
1 Reply
Anonymous
Not applicable
Author

Hi Ather,
you can write like this in tMap
databasevalue.equals("Y")?true:false. please try this once
Thanks
Srikanth