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.
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