topic Date in Integer YYYYMM format in Talend Studio

Date in Integer YYYYMM format

Anonymous — Sat, 16 Nov 2024 07:08:06 GMT

Hi,

I have a situation;where my input column is an integer that holds Year and Month (YYYYMM). Now I need to now find the previous month for the incoming integer. The output column is also an integer.

For ex:

input_col (int) output_col (int)

201811 201810

201901 201812

201906 201905

May I know how can do the same in tmap.

Re: Date in Integer YYYYMM format

Anonymous — Tue, 04 Dec 2018 18:12:58 GMT

TalendDate.addDate(row1.input_col, "yyyyMM", -1, "MM")

you'll have to cast input_col to String to use this function

Re: Date in Integer YYYYMM format

Anonymous — Wed, 05 Dec 2018 01:03:02 GMT

@evansdar wrote:
TalendDate.addDate(row1.input_col, "yyyyMM", -1, "MM")
you'll have to cast input_col to String to use this function

Thank you very much. Works like a charm...!!!