Skip to main content

Announcements
Independent validation for trusted, AI-ready data integration. See why IDC named Qlik a Leader: Read the Excerpt!
cancel
Showing results for 
Search instead for 
Did you mean: 
BA621858188
Creator

Convert Bit datatype(SQL DB) to Boolean

Hi All,

I have source as SQL Table where my column datatype is bit and requirement is to convert bit to Boolean.

Can anyone help me with the code.

Values in source as below:

T/F

Thanks.

Labels (3)
2 Replies
manodwhb
Champion II

@Vrushabh Malbari​ , You can use tConvertType to convert from one data type to another data type.

 

Please check the below link to know more about tConvertType.

 

https://help.talend.com/r/en-US/7.2/processing/tconverttype

 

Thanks,

Manohar

BA621858188
Creator
Author

do you have any job design which can clear my doubts