K3 Reconciliation allows users to manage and execute data reconciliations
This user guide will introduce you to the steps to create, manage, and execute reconciliations between two data sources in K3. It is a step-by-step guide that explains how Reconciliation works and answers the vast majority of questions.
What data is available for reconciliation?
The K3 Reconciliation tool has the ability to reconcile data from any route in K3. In order to reconcile data, that data must first exist in a K3 route. The first preparation step for creating reconciliations is to create a route which acquires and transforms data into a desired format for reconciling. Once a route is created, that route will be accessible in the Reconciliation screen.
For routes be reconciled the respective target fields used in the reconciliation must be named the same and have the same data types.
How is data reconciled?
The K3 Reconciliation tool allows users to configure how two data sets are reconciled. This includes the ability to select the fields to group by, the aggregate fields, as well as any filters that might be needed.
Group By Fields: These fields are where the aggregates will be calculated. Example, if you are reconciling data with the field "Food" as the Group By, aggregates will be calculated for all unique values in the "Food" field (apples,oranges,grapes,etc...).
Aggregate Fields and Aggregator: These fields are the fields the will be aggregated at the respective Group By. Using the example above, the aggregate field might be "Quantity" and the aggregator used could be "Sum". In this case, "Quantity" would be summed for all unique groups in the Group By (apples,oranges,grapes,etc...).