The expansion processor de-summarizing data into multiple records. It takes the entity set and creates rows based on the settings.
The following fields need to be configured:
-
Enter the following parameters in the Basic section,
-
Expanded Attributes Name -The selected fields from the entity that will be expanded on. For each row, a new row will be created per column selected. Any columns not selected here will remain as is on these new rows.
-
Target ‘Name’ Attribute Name - The name for the new field added to the entity set which will have the expansion field name as a value.
-
Target ‘Value’ Attribute Name - The name of the new field added to the entity set which will have the expansion field value as a value.
-
Generate Row for Null Value - If there is a null value in one of the Expand Attribute Names fields, an expansion row should be created
For example, configure the Expansion processor as follows:
-
Set the Expand Attribute Names set to IsBase,InstrumentLenght1SiValue
-
Set the Target ‘Name’ Attribute Name to ‘FieldName’
-
Set the Target ‘Value’ Attribute Name to ‘FieldValue’
-
Uncheck the Generate Row for Null Value.
Consider the following rows in the entity set.
The processor would display the following result:
-
-