split Field into FeildValues in Script

[#1]

hi,

Is there any possibility to split the Field in script into Field values to rename them Ie., I am loading the data from excel sheet where Feild

is identifier consists like below attachment.But i want to rename them as A for 1st record, B for 2nd and so on how to do.

I have read some post on this subject without to find a solution understandable for me.

thanks in advance.

[#2]

thanks a lot  it is working

[MindaugasBacius]

map_identifier:
Mapping LOAD * INLINE [
    F1, F2
    2.16.840.1.114416.1.24.132565, A
    2.16.840.1.114416.1.24.132574, B
];


Data:
LOAD Identifier
  ,ApplyMap('map_identifier', Identifier, ':') as Type
INLINE [
    Identifier
    2.16.840.1.114416.1.24.132565
  2.16.840.1.114416.1.24.132574
  2.16.840.1.114416.1.24.132586
  2.16.840.1.114416.1.24.132590
  2.16.840.1.114416.1.24.1382597
  2.16.840.1.114416.1.24.1382622
];

The result:

[#4]

thanks a lot it is helpfull

[oknotsen]

If your question is now answered, please flag the Correct Answer.

If not, please let us know what part of this topic you still need help with .

[Kushal_Chawda]

another way

Data: 

LOAD *,

          Pick(match(Identifier ,'2.16.840.1.114416.1.24.132565','2.16.840.1.114416.1.24.132574'),'A','B') as Type

INLINE [ 

    Identifier 

    2.16.840.1.114416.1.24.132565 

  2.16.840.1.114416.1.24.132574 

  2.16.840.1.114416.1.24.132586 

  2.16.840.1.114416.1.24.132590 

  2.16.840.1.114416.1.24.1382597 

  2.16.840.1.114416.1.24.1382622 

];