May I ask if there is any way to implement COALESCE in Talend?
I only see 'First Match', 'Unique Match', 'All Matches' with Tmap, however none of them can catch the right values that COALESCE does in SQL.
Your help is much appreciated!
Are you referring to this function https://docs.trifacta.com/display/PE/COALESCE+Function in talend ?
Yes, that's the function I'm looking for, to get the first non null value in an array of columns. It's one of the function in SQL but I could not find how to do it in Talend. My alternative way is to sort on 'All Matches' in tMap and followed by tUniqRow which is very inefficient.
U can try like this.It works.
row1.ConDate!=null?row1.ConDate:TalendDate.parseDate("yyyy-MM-dd HH:mm:ss","1970-01-01 00:00:00")
The first 100 community members completing the Open Studio survey win a $10 gift voucher.
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
Practical steps to developing your data integration strategy.