Apply map

[Anonymous]

we have data like

1

2

3

I want to show

P1

P2

P3

[senpradip007]

You can use like

'P'&[Your Field] as New_Field

[#3 · Accepted solution]

Hi ,

look at this-

TEST1:

LOAD * INLINE

[ Field

1

2

3

];

MAP:

mapping LOAD * INLINE

[ Field,FiledVAlue

1,P1

2,P2

3,P3

];

TEST:

LOAD

ApplyMap('MAP',Field) as Field1

Resident TEST1;

DROP Table TEST1;