I have been using Talend Data Preparation for a while; how do I execute the following scenario:
Say I have a column A (with date values). Now I wish to populate another column B depending on what value is found on column A. For example, if column A has a date of 25/12/2016, I would wish to populate column B with prefix Merry Christmas! and concatenated with 25/12/2016 so that the output is: Merry Christmas! 25/12/2016.
If column A is empty, I would wish to populate column B with prefix Ordinary day and concatenated with the date so that the output is: Ordinary Day 27/12/2016
Any assistance will be highly appreciated. Thank you.
The approach is to filter on column A and then apply the desired function on column B on the filtered rows only. See https://help.talend.com/pages/viewpage. … =267099901 for a detailed example.