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
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.