Compare dates between rows from the same input file based on ID and replicate rows by increment date

[Anonymous]

Hi Team,

I am trying to duplicate rows by comparing the date of the current row with date of the next row for a user ID and row should be duplicated by incrementing the date where < date of the next row.

To explain in detail

input:-

User_ID	Start_DateMonth	Start_DateDAY
101	201601	1
101	201604	2
101	201607	11

Compare Start_DateMonth of first row with second row and replicate the row by incrementing the Start_DateMonth till the Start_DateMonth of the second row of the input

Expected Output:-

User_ID	Start_DateMonth	Start_DateDAY
101	201601	1
101	201602	1
101	201603	1
101	201604	2
101	201605	2
101	201606	2

Please suggest if this logic can be implemented in Talend.

Thanks & Regards

SJ