Town; Type; Number
Town 1; Type A; 4
Town 1; Type A; 2
Town 1; Type B; 6
Town 2; Type A; 7
Town 2; Type B; 11
Town 3; Type C; 21
Town 3; Type A; 32
Town 3; Type B; 3
Town 3; Type B; 4
etc.
How would I get my source data set to look like this? Town; Type A; Type B; Type C; Sum Town 1; 6; 6; 0; 12
Town 2; 7; 11; 21; 39
Town 3; 32; 7; 0; 39
I have tried using the new AttributePivot on Town and Type, but it would give me this result really.
The BulkAttributeRenamer can be used effectively.
1) BulkAttributeRenamer
Rename: Selected Attributes
Seleted Attributes: Number
Action: Regular Expression Replace
Text To Fine: .*
String: Type (Attribute Value)
2) AttributeExposer
Attributes to Expose: Type A, Type B, Type C
3) Aggregator
Group By: Town
Mode: Attributes Only
Keep Input Attributes: No
Attributes to Sum: Type A, Type B, Type C
4) AttributeCreator
Sum = @Value(Type A)+@Value(Type B)+@Value(Type c)
Takashi
1) AttributeCreator
@Value(Type) = Number (Set value of "Type" to new attribute name)
Sum = Number
2) AttributeExposer
Attributes to Expose: Type A, Type B, Type C
3) Aggregator
Group By: Town
Mode: Attributes Only
Keep Input Attributes: No
Attributes to Sum: Sum, Type A, Type B, Type C