Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
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.