field value group

[everest226]

hi i have a field  (Name ) which has following value   ,

AA BB CC DD  i want to  to have AA, BB   as BA   and rest as same way 

[Saravanan_Desingh]

Are you looking something like this?

Mapper:
Mapping
LOAD F1,'BA' INLINE [
    F1
    AA
    BB
];

tab1:
LOAD F1, ApplyMap('Mapper',F1) As F2 INLINE [
    F1
    AA
    BB
    CC
    DD
];