Your Navigation Path
Case Base
MiningMart
Case
TemplateCase
Chain
PivotisationDemo

Step: ReversePivotize

Name ReversePivotize
Belongs to Case TemplateCase
Uses Operator ReversePivotize
Belongs to Chain PivotisationDemo
Concepts of resulting Data Model Client
CreditFraud
InhabitantsData
InputAssociationRules
PersonalData
Product
WhoBoughtWhat
ReversePivotised
Has Parameters IndexValues0
IndexValues1
IndexValues2
IndexValues3
IndexValues4
IndexValues5
IndexValues6
IndexValues7
IndexValues8
NameForPivotAttribute
NamesForIndexAttributes0
NamesForIndexAttributes1
TheInputConcept
TheKeyAttribute
TheOutputConcept
ThePivotizedAttributes0
ThePivotizedAttributes1
ThePivotizedAttributes2
ThePivotizedAttributes3
ThePivotizedAttributes4
ThePivotizedAttributes5
ThePivotizedAttributes6
ThePivotizedAttributes7
ThePivotizedAttributes8

M4 Documentation:

This step demonstrates the use of the operator 'ReversePivotize'. Note that the reversal of pivotisation only reverses the way the data is organised, but it cannot reverse the aggregation of data for obvious reasons. So the input of this step has special attributes for each combination of wind and type-of-weather, while in the output there are only two attributes for these, and each combination of values of these attributes occurs in the data rows. The time information in the original 'WeatherData' set (which was used as input for the 'Pivotize' step) is lost because aggregation was performed over it: the sum of rainfalls over a number of days was computed, from which the daily rainfalls obviously cannot be recovered.