Grouping of states

[ashraf_qlik]

Hi,

I have a column 'States' in data where states names are

Delhi , Haryana , UP , MP, Bihar, Rajasthan, Assam , Manipur, Tripura , AP, Tamilnadu, Goa.

My report required these states to be clubed and give a new name as per below,

Delhi , Haryana , UP  as NCR

Assam , Manipur,Tripura as NE 

Rest states as it is.

I want to do this while loading the script, please suggest

[sunny_talwar]

May be create a new field like this

LOAD States,
     If(Match(States, 'Delhi', 'Haryana', 'UP'), 'NCR'
     If(Match(States, 'Assam', 'Manipur', 'Tripura'), 'NE', States)) as GroupedStates
     ...
FROM ...;