Intellicus Kyvos Reporting Query Objects support two types of merging of data sets.
...
Join – includes Equi and Outer joins
...
data set merging: Join and Union.
Join
This step takes two inputs. When the data is passing through this step, the data of both inputs will be joined based on properties set for this step.
Figure 14: Join Step
...
The Join step properties are:
...
Property
...
Values
...
The Join step combines data from two inputs based on specified properties and conditions.
Properties of Join Step
Property | Description |
|---|---|
Select All Fields | Select |
Select =
: All fields from both |
sources |
are included in the output |
. Duplicate field names |
are renamed automatically |
(e.g., |
De-select = You can choose which fields should be available in the output of this step
Choosing is done by selecting the check box adjacent to field names of both inputs). | |
Join Type | Select |
the desired type of join: |
Inner Join |
, Left Outer |
, Right Outer |
, Full Outer. |
Join Conditions |
Specifies the |
Join Conditions
Field name Operator Field Name
Forms the Join Key
Union
Union step takes two or more inputs. The data passing through this step appends to one another and forms a single output.
Generally, the data inputs selected for Union are of same structure i.e. the columns are same. But this step supports exceptions and allows having extra columns in some inputs. You can decide whether to carry forward the fields coming from only some inputs to output.
During the union process you can decide to take out the sorted or you can prefer unsorted appending.
Figure 15: Union Step
...
The properties of Union step are:
...
Property
...
Values
...
Comments
...
Union Type
Unsorted
Sorted
...
The output of this step shall be sorted or not
...
Sort Priority
...
Number 1-3
This property is at field level.
This is set below the field name.
Set the number 1, 2 or 3 to the fields which should be sort key
...
Sort Criteria
Ascending
Descending
...
Sorting criteria as either ascending or descending order
...
Remove Duplicate Rows
...
Select/De-select
...
Select = To get distinct rows from Union step
...
Column
...
Enter
The selected field name populates automatically.
You can change the caption of the resultant field.
You can perform the actions on columns as mentioned in the below table
Action Button
Comments
Add Column
To add a new column
Rename Column
To apply typed name to the selected column
Delete Column
join key by mapping fields between the two inputs. The condition is formed by Field Name, Operator, and Field Name. |
...
Union
The Union step appends data from two or more inputs into a single output. This step supports merging inputs with equal or unequal column structures.
Properties of Union Step
Property | Description |
|---|---|
Union Type | Unsorted or Sorted. Defines whether the output is sorted or unsorted. |
Sort Priority | Set sorting priority for fields (1, 2, or 3) to define order of sorting at the field level. |
Sort Criteria | Defines sorting order as either Ascending or Descending for the output. |
Remove Duplicate Rows | Select: Ensures only distinct rows are included in the output. Clear: Allows all rows, including duplicates. |
...
Actions on Columns
Action Button | Description |
|---|---|
Add Column | Adds a new column to the output. |
Rename Column | Allows renaming of the selected column. |
Delete Column | Removes the selected column. |