How to create New Dimension based on exist field

[Naps_230]

Hi Team,

I need to replace ID field with Requireoutput field should contain ('FM RS'+ Running number). How to create new Requireoutput field based on  'FM RS'+ Running number this logic in frontend and backend. let me help

Source data:

ID	sales
100	5550
50	7000
40	8000
33	9000
1459	5000
200	9000
23	2000

Output data:

Requireoutput	sales
FM RS 1	5550
FM RS 2	7000
FM RS 3	8000
FM RS 4	9000
FM RS 5	5000
FM RS 6	9000
FM RS 7	2000

[MartW]

in the backend you can add the autonumber function in combination with a bit of text.

you can do something like this:

Load *,
'FM RS '& autonumber(ID) as Requiredoutput
;
Load * inline [
ID,sales
100,5550
50,7000
40,8000
33,9000
1459,5000
200,9000
23,2000
];

I don't think you should try this within the frond-end. because you want to create a key.