Grouping of values from same field

[aatish12345]

Hello Everyone,

I have a field consisting of below values

Field1:

A

B

C

D

E

Here I want to group only A , B and C together and called it as 'Group1' and want to keep D as it is and the value E should not appear in the final output as shown below:-

New Field:

Group1,

D

Can you please help me achieve this?

Aatish

[sasikanth · Accepted solution]

HI, 

try below one

load *, If(Field1='A' Or Field1='B' Or Field1='C','Group1', if(Field1='D','D')) as New_Field;

load * inline

[

Field1:

A

B

C

D

E

];

[anat · Accepted solution]

Can u try using applymap by creating mapping table

[aatish12345]

Hi Sasikant and Anat...

Both the solutions are working as expected...

Thanks 

Aatish