Creating Groups on values

[amars]

Hi all,

I have a database , in which suppose I have hundred possible values for a field. Of which I wish to put some values in one group , similarly I wish to create Groups based on values & it should be dynamic with the no of values but the no of groups will remain constant. Can I do it by some other way like Inputsum or something like that.

E.g. GROUP , FieldValue

Group1, (a1,b3,d5,h7,e9,a11,x15)

Group2, (abc1, p2, z12, ab23)

Something like this. Both values for GROUP & FieldValue are present in my qvw. thanks in advance.

Regards

Amar

[prieper]

You will need to create a separate table, listing all Fieldvalues and the assignment to a group, like

Grouping:
LOAD * INLINE [
FieldValue, Group
a1, Group1
b3, Group1
abc2, Group2
p2, Group2];

HTH
Peter