topic How to write if and else condition check for the date pattern in tMap in Talend Studio

How to write if and else condition check for the date pattern in tMap

Anonymous — Sat, 16 Nov 2024 04:28:51 GMT

Hello all

I have a requirement like below

Date1	Date2
6/2/2018	7/2/2019
null	7/25/2019

If the Date1 is null i need to populate the value from Date2 in the target

If the Date1 is not null i need to populate the value as current date in the target

My expected output column

output

today's date (11/03/2019)

7/25/2019

Thanks In Advance

Manish

Re: How to write if and else condition check for the date pattern in tMap

TRF — Thu, 03 Oct 2019 17:22:43 GMT

row1.date1 == null ? row1.date2 : TalendDate.formatDate("MM/dd/yyyy", TalendDate.getCurrentDate())

Re: How to write if and else condition check for the date pattern in tMap

Anonymous — Thu, 03 Oct 2019 17:40:09 GMT

Thanks @TRF

Am getting cannot convert string to date error, can you please help me out how to resolve it

Re: How to write if and else condition check for the date pattern in tMap

TRF — Thu, 03 Oct 2019 17:53:38 GMT

Just change for this if datatype is date:
row1.date1 == null ? row1.date2 : TalendDate.getCurrentDate())
In this case formatting doesn't make sense, a date is a date...

Re: How to write if and else condition check for the date pattern in tMap

Anonymous — Thu, 03 Oct 2019 17:59:52 GMT

@TRF

row1.date1 == null ? row1.date2 : TalendDate.getCurrentDate() i used this, so it worked out as per my need thanks @TRF