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.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema