I am trying to load and transform data using Talend. I have to extract latest rows based on datetime field. I convert data type using tMap and cast it to Date with format dd-MM-yyyy HH:mm:ss. Performed aggregation, things are moving as expected and my dataset reduced from 10 columns to 4 columns(fields I used to perform aggregation) and rows also got reduced from 24 to 13.
I want to extract all the columns based on the result set return by the tAggregateSortedRow component. But the problem, I am facing is the former one has date format dd-MM-yyyy hh:mm:ss and new filedelimiter has data type string with format (MM/dd/yyyy HH:mm:ss). I used tConvertType but still facing the same issue. PF workflow below.
Can you please help me to get the correct workflow.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema