I'm using this csv file in talend and I already ordered by category (categoría in spanish) and calculate which is the result of the sellings (total = price(precio) * quantity (cantidad)) and it worked.
Now I'm making it more complex and I added a date row(fecha) because I want to order it by date, using the day and month to calculate the sellings as well.
This is the flow in the tmap:
I hope I could explain myself.
Thank you so much
Try Talend Cloud free for 30 days.
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.