Can you please advise me how to get the highlighted data through tMap coding?
For the same PO, the source report contains multiple records. the highlighted one is the latest one which I need for the result.
For now I do not have any idea to achieve this.
Thanks for the help!
better to use tAggregateRow
of course you can store data to tHashOutput and then use in tMap for join with all data (if you need this)
Thank you for the reply. I have tried using tSortRow to DESC the date. But then I got reverse dates.
The flow I created is below as well - not sure which part has problem. tMap_1 is used to transfer "String" to "Date" data type. Then I sorted both ETD and ETA DESC. the second tMap is used to do the logic for my task.
I took below as input
read file (while reading you could read it as Date with pattern MM/dd/yyyy) --> tsort (on 2nd col desc then 1st col desc then 3rd col) --> tsamplerow ( for test -to get 1st 2 record) --> tLogrow
i got this as output
But if you are not doing any lookup in tMap( 3rd column) after tsortRow , better to go with tAggregateRow/tAggregateSortedRow.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.