Knowledge Base

Determining Source Grouping

How can we help?

Browse Common Categories

Getting Started with

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.

Email an Expert

Start a Ticket

Chat with Us


Submit a Ticket


Call Us

  • Microsoft Dynamics 365
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?