I didn't manage to find a good subject name so let me explain in details :
I have those fields. As you can see there are client, service and time.
What i want is to get for each client :
- the time total (sum of all time for the same client )
- time for each service
I managed to get the total time for each client with a tAggregateRow but now i can't figure out how to get the time for each service.
Example of what i want :
|ClientA|150 |45 |50 |55 |
|ClientB|99 |33 |33 |33 |
I don"t know how i can get all the service, place them in the colum name and get the sum of the time by client for every service.
If it's not clear enough, ask me.
Thank you in advance !
Solved! Go to Solution.
Input data :
First col : Client;
Second : Service;
Third : Time.
As you can see, for one client there are different services and time corresponding.
So the output for the client RESAMANIA/STADLINE would look like :
|Resamania/STADLINE|180 |60 |120 |
Tell me if you need more information.
Thank you anyway hpamidipola !
Thanks for trying to help me !
Unfortunately, i can't find the components tHashOutput/Input on my talend version.
I checked on Talend Exchange also and i didn't find them neither.
Do you have a link for me to DL it ? Else, is there another way to do it, maybe without that component.
Thank you in advance
1: On the main menu navigate to File –> Edit Project properties
2: Select Designer –> Palette Settings
3: Go to technical –> select tHashInput/tHashOutput and press the right arrow.
If you have more data please use file/DB components instead of hash components. The reason why i used the hash components is, i considered less data(only 3 records).
Please give Kudos and mark topics as solved where appropriate.
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