Finding greatest between two dates

Six Stars

Finding greatest between two dates

Gurus,

Can anyone let me know what is the function in talend for comparing 2 dates and finding the greatest?

greatest (dt1, nvl(dt2,dt1)) as date.

Thanks

Forteen Stars TRF
Forteen Stars

Re: Finding greatest between two dates

Six Stars

Re: Finding greatest between two dates

Thanks! TRF for your quick reply. is there a function to handle it in tmap?I am using 2 tables for comparing the date columns?
Highlighted
Forteen Stars TRF
Forteen Stars

Re: Finding greatest between two dates

Join both tables with a tMap then you can compare dates from main and lookup tables using the appropriate expression based on TalendDate routines.

TRF

Tutorial

Introduction to Talend Open Studio for Data Integration.

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.