topic Re: How to implement COALESCE in Talend? in Talend Studio

How to implement COALESCE in Talend?

Anonymous — Tue, 12 Dec 2017 02:04:26 GMT

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!

Best,

Billy

Re: How to implement COALESCE in Talend?

Anonymous — Thu, 14 Dec 2017 07:00:43 GMT

Hello,

Are you referring to this function https://docs.trifacta.com/display/PE/COALESCE+Function in talend ?

Best regards

Sabrina

Re: How to implement COALESCE in Talend?

Anonymous — Thu, 14 Dec 2017 07:47:57 GMT

Hi Sabrina,

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.

Thanks!

Best,

Billy

Re: How to implement COALESCE in Talend?

Anonymous — Tue, 15 Jan 2019 14:26:18 GMT

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")