Skip to main content

How to aggregate and merge data in the Rules Engine


spencer_engel
Forum|alt.badge.img+4
Hi everyone -

I've put together a how-to video that explains how to aggregate data and then merge with another dataset to get everything you need. The use case here is that I want to find the nearest-in-the future close date for an opportunity (a.k.a. MIN Close Date) and then still pull over other key attributes from that opportunity (Amount, Owner ID Name, etc.).

Here's how to do that.

https://player.vimeo.com/video/333166700

Did you find this topic helpful?

2 replies

Forum|alt.badge.img+1
  • Contributor ⭐️⭐️
  • 7 replies
  • April 1, 2021

This is great to understand merging data sets, but I believe you should have merged on Account ID and/or Opportunity ID. Doing it the way you did is fine if there are only a few Opps in the same account, but what if you have multiple Opps with the same Close Date? You’ll again just pull a random amount. 


spencer_engel
Forum|alt.badge.img+4
  • Author
  • Expert ⭐️
  • 669 replies
  • April 14, 2021
pgrajek wrote:

This is great to understand merging data sets, but I believe you should have merged on Account ID and/or Opportunity ID. Doing it the way you did is fine if there are only a few Opps in the same account, but what if you have multiple Opps with the same Close Date? You’ll again just pull a random amount. 

Yeah, that’s a good point and should be considered especially in a use case where a customer may have a whole bunch of opportunity records.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings