topic Re: Create an aggregate with group By and Having field with a fixed value in Talend Studio

Create an aggregate with group By and Having field with a fixed value

chou — Wed, 24 Apr 2019 16:32:10 GMT

Hello,

I want to do calculate the sum of MOPE having same NCRECRI and COPE= "DRB"

the variable DRB is a fixed value of DRB, that I have put it in the entry link.

but as a Result it doesn't take into account the cope = DRB, he is making the sum of all MOPE having same NCRECRI and COPE

Can you help me please? should I use another component?

joearun4u — Thu, 25 Apr 2019 06:14:01 GMT

Before passing the values into tAggregaterow, filter the values in tFilterrow i.e, COPE= "DRB".

Try and raise your question if you still getting the same error.

Thanks,

Joe

Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.