Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
My source is cassandra DB (data type is boolean) and target is Mysql(data type is tinyint(1)).
I used below Inline condition,but i am getting only 0 value in "External" field, no single 1 value for "True" in target Mysql.
user.external.equals("true") ? 1 : 0
I have a an string in source "external" with "True/False" as value and in target i have a tinyint type with bit(1) which hold only 1 OR 0.
so i want convert "True/False" to "1/0".
Best regards,
Hi TRF,
Getting error.
Is user.external daclared as a boolean field on Talend side?
Hi TRF,
Below is my mapping in tMap.Thanks.
Hi TRF,
Yes, declared as a boolean field on Talend for cassandra(source) side and integer for Mysql (Target)side.
I confirm it works.
Here is a tMap with the required expression as an example: