AnsweredAssumed Answered

How to update the minimum value into the aggregated data?

Question asked by deepa.govind@integration.works on Dec 17, 2017
Latest reply on Dec 18, 2017 by deepa.govind@integration.works

I have this requirement to group values(based on year|make|model) and display the minimum(avgretail).

 

 

 

 

 

year

makecode_description

family_description

AvgRetail

2010

Mazda

Demio

9300

2010

Mazda

Demio

9200

 

 

 

 

 

 

 

 

Expected output:

{
"make" : "
Mazda ",
"model " : "
Demio ",
"year" : "2010",
"avgretail" : "9200",
}

 

But Actual Output:

{
"make" : "
Mazda ",
"model " : "
Demio ",
"year" : "2010",
"avgretail" : "9300",
}

 

 

I have followed the https://community.boomi.com/thread/6107 and https://community.boomi.com/thread/2300 and split the document on year,make and model and have “Enforce Unique” enabled on all these fields, through which I have aggregated them as needed.

 

 

Below logs show the first-time value(9300) is mapped to the Output Element[avgretail] but the next time(9200) is not mapped although it is SET. 

 

 

Appreciate your help.

Cheers

Deepa

Outcomes