Create a new grouping field out of existing field

[#1]

Hi All,

I want to create a new field name grouping based on another felid like this:

field 1, new field

a,     x

a,     x

b,     y

b,     y

c,     x

d,     x

f,     y

Means I want to say if filed 1 is a,b,c,d then new filed is x and if it's b,f then is y.

Thanks,

[MayilVahanan · Accepted solution]

HI

Try like this

Load *,if(match(field1,'a','c','d'),'x','y') as NewField;

Load * Inline

[

field1

a

a

b

b

c

d

f

];

Hope it helps