[resolved] HELP - HOW TO Quarter IN MY TMAP

Anonymous — Thu, 17 Sep 2015 14:14:58 GMT

Dear all,

I am making transformation in my tMap, and i have a column of date type, so i want to get output data each quarter of the reference date
For exemple:
INPUT DATA
Date (MM/dd/yyyy) ; Info
03/16/2014 ; Hello world

OUTPUT DATA
Date (MM/dd/yyyy) ; Info
03/16/2014 ; Hello world
06/16/2014 ; Hello world
09/16/2014 ; Hello world
12/16/2014 ; Hello world
03/16/2015 ; Hello world
..................
...............

Thank you for help,

Re: [resolved] HELP - HOW TO Quarter IN MY TMAP

Anonymous — Thu, 17 Sep 2015 14:43:22 GMT

Hi
Take a look at this built-in function: TalendDate.addDate(Date yourDateColumn, int nb, String datePart). In this case, you need to add 3 in the month part.
TalendDate.addDate(row1.dateColumn, 3, "MM")
Best regards
Shong

topic Re: [resolved] HELP - HOW TO Quarter IN MY TMAP in Talend Studio

[resolved] HELP - HOW TO Quarter IN MY TMAP

Re: [resolved] HELP - HOW TO Quarter IN MY TMAP