Sum similar data in order to perform a multiplication

Six Stars

Sum similar data in order to perform a multiplication

Hello, community:

 

I'm having some issues with grouping a same date, even when I already extracted the month and the day in integer type.

My question is, how can I group those and if it is possible to multiplicate once I had the result.

I leave here the excel file I'm using and the screenshots of the tmap and the taggregate I'm using for this topic.

 

Best regards and thank you for the support,

Daniela MunizCaptura de pantalla (10).pngCaptura de pantalla (11).pngCaptura de pantalla (12).png

Daniela Muniz

Accepted Solutions
Six Stars

Re: Sum similar data in order to perform a multiplication

It has a solution and this is what I did:

 

1. Put two metadata files into the job

2. Join the files with tmap, ordering them as I want them to appear in the output log.

Captura de pantalla (13).png

3. Add a taggregate in order to group the output data, I don't know if it's necessary, but I used one taggregate per transaction/group with the characteristhics and it worked.

Captura de pantalla (14).png

 

4. Add a tfileOutput file I wanted my records to be located at.

 

 

This is the final result:

Captura de pantalla (15).pngThanks a lot to everyone for the support.

 

Best regards,

Daniela Muniz

Daniela Muniz

All Replies
Community Manager

Re: Sum similar data in order to perform a multiplication

Hi DanishKapoor  

From your screenshot, i don't see you group the date column, what is the your issue? What are your expected result?

 

Regards

Shong

----------------------------------------------------------
Talend | Data Agility for Modern Business
Six Stars

Re: Sum similar data in order to perform a multiplication

It has a solution and this is what I did:

 

1. Put two metadata files into the job

2. Join the files with tmap, ordering them as I want them to appear in the output log.

Captura de pantalla (13).png

3. Add a taggregate in order to group the output data, I don't know if it's necessary, but I used one taggregate per transaction/group with the characteristhics and it worked.

Captura de pantalla (14).png

 

4. Add a tfileOutput file I wanted my records to be located at.

 

 

This is the final result:

Captura de pantalla (15).pngThanks a lot to everyone for the support.

 

Best regards,

Daniela Muniz

Daniela Muniz