Hi Talend Folks,
I have a date column in excel. The values are below like format.
I need to create to_date column and ignore first value then assign remaining values for To_date column.
This is my scenario. I need below output
You need to think about this in reverse and get the previous record to achieve this. I answered a very similar question to this here: https://community.talend.com/t5/Design-and-Development/How-to-get-previous-row-tuple-s-value-without...
This solution as it is will naturally lead to your first row having a null date instead of your last row. So you will have to either reverse the order of your rows before you do this and reverse them again afterwards. You can do this with a tSortRow component
Similar to @rhall_2_0s solution, sort them into reverse order and use the tMemorizeRow component.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Accelerate your data lake projects with an agile approach