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.
Join us live for a sneak peek!
Create systems and workflow to manage clean data ingestion and data transformation.
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.