Use data twice in the same output

[TGuillerm]

Hi

I found myself stuck at this moment i need to get data from 2 column to 3 ! So the data are like this in the input file : Date , Button /n .

So i need the column to be like this :

Date(row1),Date(rowx),Button1

Date(row2),Date(rowy),Button2

Date(rowx),Date(rowx'),Button1

.....

I need the date when the button 1 is pressed for the begining and the end of the operation and also verify if the name of the button match each other.

I did a Python program which show what i want to do in Talend !

So there is a Table with 2 collumn one for the date and one for the button and when in run the program i get at the end 3 collumn with the Date in the order i explain earlier !

If someone had any clue it will be a big help !! 😄

Thank you !

[manodwhb]

@Tristan Guillerm​ , Can you share sample input and output data.

Thanks,

Manohar

[TGuillerm]

1147 is the input file type

So on 1147 file you can find 2 collumn one for the date and one for the button which has been pressed and i need to transfer them using this patern

I don't have the real output file because i need to create it out of scratch.