Creating the Grouping Attribute

Shubha

Hi RM,

I have a data like the below:

Index Val
X1 3
X2 6
X3 7
X1 4
X2 6
X3 4
X1 5
X2 9
X3 5

I need to create another attribute to this data, indicating the groups. i.e., the values in this attribute should be like,

Group
1
1
1
2
2
2
3
3
3

i.e., the first X1, X2, X3 belong to group1, the second X1, X2 and X3 to group2 and so on for 'n' number of groups...

How do i do this? I am attempting this so that i can then use the "Example2AttributePivoting".

Many Thanks,
Shubha