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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
BA621858188
Creator
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
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
Creator
Author

do you have any job design which can clear my doubts