topic Tmap problem in Talend Studio

Tmap problem

ARamundo1687543498 — Fri, 15 Nov 2024 21:38:42 GMT

Hi, I’m Alessio Ramundo and I’m a student of the University of Calabria (Italy). I found a problem with the component tmap. When I choose the function getpartofdate, in the section ‘expression’ I can choose ‘month’,’year’ or other as documentation. But if I would the semester or the quarter, is there a solution for this? I tried to write ‘SEMESTER’ or ‘QUARTER’ but it doesn’t work. I have only 0.

thank you very much for the attention.

Re: Tmap problem

anselmopeixoto — Fri, 23 Jun 2023 19:07:59 GMT

Hi Alessio,

Unfortunately there aren't SEMESTER and QUARTER expressions for the getPartOfDate method, but you can achieve the same result by doing a division over the MONTH expression result:

QUARTER: (TalendDate.getPartOfDate("MONTH", input_date))/3+1 //add one at the end to start at quarter 1 instead of 0

SEMESTER: (TalendDate.getPartOfDate("MONTH", input_date))/6+1 //add one at the end to start at semester 1 instead of 0

I hope it helps.

Best regards,

Anselmo