Knowledge Base

Determining Source Grouping

How can we help?

Browse Common Categories

Getting Started with SmartConnect.com

Determining Source Grouping

  1. Under the Integration tab click on the Source Grouping tab.

  2. The Name and Type fields will default.
  3. Function column – the user can choose a function to be applied to the data that will be grouped.
    1. First – returns the first record from the source.
    2. Last – returns the last record from the source.
    3. Max – returns the record with the largest value.
    4. Min – returns the record with the smallest value.
    5. Sum – returns a sum of the column if it is numeric.
  4. Group By – sets the grouping at the record/transaction level. This will normally be the unique identifier for master records, or the field(s) used to identify one transaction from another.
Support

Email an Expert

Start a Ticket
Support

Chat with Us

Support

Submit a Ticket

Support

Call Us

Product
Connections
  • Microsoft Dynamics 365
Templates
Engage
Get Started

SmartConnect is designed with specialty & deep experience in the core technologies we focus on.

iPAAS & on-premise integration tools that let you connect your cloud and on-premise applications.

© 2021 SmartConnect|eOneSolutions
Privacy PolicyTerms of ServiceEULA

How can we help?

clear