Solved! Go to Solution.
Thanks for the response, but what is tenary notation? Should I just put this on the expression for the target column that should be updated or?
And actually I want to base the values of the column that needs to be updated base on the values from another column on the same table. Is this will work with that?
In my file i will get two columns Column_A & Column_B such that only one of the value is NULL
I need to map the above column values to my column in db called VALUE.
I am using ternary operation in Tmap such that i need to populate only one the value from two columns giving preference to column_A.
Above logic is not working properly, when Column_A is null, it should be populating Column_B which is not NULL, but it is populating as NULL.
Please help me.
Thanks for the suggestion Abshishek,
Below is my logic in Tmap:
(row19.questionAnswerFreeText == null || "".equalsIgnoreCase(row19.questionAnswerFreeText))?( (row19.questionAnswerText) == null || "".equalsIgnoreCase(row19.questionAnswerText)
?null : (row19.questionAnswerText)) : row19.questionAnswerFreeText
Still its not working.
Join us at the Community Lounge.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.