Hi everyone. I'm new with talend open studio . I have some trouble when using it. Is there any way to I can get my expected output from this input? INPUT DATE (yyyymmdd) | ip | FINISHED ( 1:finished; 0: not finish) 2017-01-01 | 111 | 1 2017-01-01 | 222 | 1 2017-01-02 | 333 | 1 2017-01-03 | 444 | 1
you have to link row 13 and row 14 to row 15
then on the output hoan_thanh write:
(comparDate(row15.finished_Timestamp, row15.finished_Timestamp)>0)?"1":"0"
I followed your instruction then linked it but unfortunately when I linked it but row15.finished_timestamp still get null in that row ( I checked the same data pattern, compare with just yyyy-MM-dd ). the output full of 2 and of course I did'n change anything in tmap setting)
You asked me to link row13 into row15. Row13 contains date . If I don't link it in row15 don't have any date so date contains will be null. Should I add a column finished_timestamp into the finished csv?
Like you said , I didn't like row13 into row15 . However, I add to file finished a col wich is finished_timestamp than in the output just like in picture but the file still all in 2.In file data I sure it has the date. I format the date in data pattern just like the formate in file .
