topic Re: Check date in a particular date range using tmap filter in Talend Studio

Check date in a particular date range using tmap filter

mks02 — Wed, 27 Sep 2017 01:26:29 GMT

How do I check if a Date exists within a specific date range?

I am joining a pipeline which comes from jdbcInput--> tmap1--> tMap_join -->tOutputExcel
For tMap_Join : I am joining a SQL DB table with tMap1 out result. all dates column are in 'yyyy-MM-dd' format.

I need to check : tmap1.st_dat >= sqlTable.st_dat AND tmap1.end_dat <= sqlTable.end_dat

in tmap_join filter area.

How do i achieve this??
Attaching screenshot for this.

Re: Check date in a particular date range using tmap filter

Anonymous — Wed, 27 Sep 2017 05:13:09 GMT

Hello,

Could you please elaborate your case with an example with input and expected output values?

Best regards

Sabrina

Re: Check date in a particular date range using tmap filter

mks02 — Tue, 03 Oct 2017 06:38:00 GMT

I have check the data and write condition below for this:
(TalendDate.compareDate(tmap1.st_dat, sqlTable.st_dat ==1 || TalendDate.compareDate((tmap1.st_dat, sqlTable.st_dat) ==0) &&
(TalendDate.compareDate(tmap1.end_dat, sqlTable.end_dat) ==-1 || TalendDate.compareDate((tmap1.end_dat, sqlTable.end_dat)) ==0)

We can understand TalendDate.compareDate by this :
Date1 < Date2   : Returns -1
Date1 = Date2   : Returns 0
Date1 > Date2   : Returns 1

Above condition works for me.

Re: Check date in a particular date range using tmap filter

Anonymous — Mon, 03 Dec 2018 12:54:50 GMT

How to filter date something like -- if today == Monday then filter from current date - 2 days (Sat and Sun) else filter date from current date

Re: Check date in a particular date range using tmap filter

manodwhb — Mon, 03 Dec 2018 13:07:02 GMT

@ADee,you need to use the below way.

TalendDate.getPartOfDate("DAY_OF_WEEK",TalendDate.parseDate("dd-MM-yyyy HH:mm:ss", "13-10-2010 12:23:45"))==2 ?TalendDate.addDate(TalendDate.getCurrentDate() ,-1,"dd") :TalendDate.getCurrentDate()

Re: Check date in a particular date range using tmap filter

Anonymous — Mon, 03 Dec 2018 13:56:51 GMT

@manodwhb Thanks for the help however how would this help in terms of range filter in Date?

as we have not mentioned any range like BETWEEN query!

Example

I have set of records

12-01-2018

12-02-2018

12-03-2018

12-04-2018

If I run my job today (Monday) output should have 3 records

12-01-2018

12-02-2018

12-03-2018

if i run it tomorrow then the output will be 12-04-2018