AnsweredAssumed Answered

Has anyone successfully handled grouping and calculating a minimum value?

Question asked by 53587767 on Mar 9, 2016
Latest reply on Mar 15, 2016 by 53587767

I have a couple columns of data; Project and ProductLineRank. In a document, the project will be repeated several times and the ProductLineRank will be the rank assigned to that product line. The dataset represents a list of products sold by project and the associated ranks. Like so:

ProjectProductLineRank
Project12
Project13
Project15
Project23
Project24

 

I push these results into a data process step where I'm trying to combine the documents and calculate the minimum value (highest rank) such that each project only has one line. In this case, I would want the output to be:

 

ProjectProductLineRank
Project12
Project23

 

Has anyone had success using aggregate functions using groovy in a custom scripting step within a data process step? That's how I'm trying to handle it but I'm unfamiliar with scripting. Or is my approach totally wrong?

 

Thanks,

Keith

Outcomes