Sum similar data in order to perform a multiplication

[Anonymous]

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 Muniz

[Anonymous]

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

[Anonymous · Accepted solution]

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.

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.

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

This is the final result:

Thanks a lot to everyone for the support.

Best regards,

Daniela Muniz