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
