topic Re: Sum from different criteria in Talend Studio

Sum from different criteria

Anonymous — Tue, 28 May 2019 14:49:28 GMT

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 !

Re: Sum from different criteria

Anonymous — Tue, 28 May 2019 14:56:29 GMT

Hi,

Please provide 2 or more records of your input data and its corresponding output.

Re: Sum from different criteria

Anonymous — Tue, 28 May 2019 15:31:08 GMT

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 !

Re: Sum from different criteria

Anonymous — Tue, 28 May 2019 17:34:50 GMT

Hi,

We have many ways to do your requirement but i did it as follows.

Please give Kudos and mark topics as solved where appropriate.

Re: Sum from different criteria

Anonymous — Wed, 29 May 2019 08:27:48 GMT

Hi 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

Re: Sum from different criteria

Anonymous — Wed, 29 May 2019 10:43:22 GMT

Hi,

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.

Re: Sum from different criteria

Anonymous — Wed, 29 May 2019 11:20:53 GMT

I actually have more rows (5000-6000) . I receive that data from a tRest (post request). What can you advise me to use to do it ?

Re: Sum from different criteria

Anonymous — Wed, 29 May 2019 11:55:13 GMT

Hi,

You can use hash components.