topic compare Date between 2 dates in Talend Studio

compare Date between 2 dates

Anonymous — Sat, 16 Nov 2024 05:21:52 GMT

Hello,

I have 2 Tables

Dates.txt:

Date

2019-05-05

2019-05-20

2019-05-30

SecondTable.txt:

Week,StartDate,EndDate

Week1,2019-05-01,2019-05-07

Week2,2019-05-08,2019-05-14

Week3,2019-05-15,2019-05-21

Week4,2019-05-22,2019-05-31

Need Result as :

Date

2019-05-05 Week1

2019-05-20 Week3

2019-05-30 Week4

i have use Comparedate but not working..So please help.

Re: compare Date between 2 dates

Anonymous — Mon, 08 Jul 2019 04:34:03 GMT

Hi,

The issue can be resolved by below method. Please refer the screenshots.

The function is as shown below.

TalendDate.compareDate(row2.StartDate,row1.date)<=0 && TalendDate.compareDate(row1.date,row2.EndDate )<=0

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂