Create an ID_COUNTER within a field

[andrew001]

Hi

From this table

tab1:
load *

inline
[CTP, EMAIL, ADDRESS
012,a012_1@d.com,via_xyx
012,a012_2@d.com,via_xyx
012,a012_3@d.com,via_xyx
014,a014_1@d.com,via_xyx
014,a014_2@d.com,via_xyx
016,a016_1@d.com,via_xyx
018,a018_1@d.com,via_xyx
018,a018_2@d.com,via_xyx]

I'd like to obtain a table like (by script) this: with a ID_COUNTER within CTP field:

ID_COUNTER   CTP EMAIL        ADDRESS

1           012 a012_1@d.com via_xyx

2           012 a012_2@d.com via_xyx

3           012 a012_3@d.com via_xyx

1           014 a014_1@d.com via_xyx

2           014 a014_2@d.com via_xyx

1           016 a016_1@d.com via_xyx

1           018 a018_1@d.com,via_xyx

2           018 a018_2@d.com via_xyx]

Thanks

[somenathroy · Accepted solution]

tab1:

load *

inline

[CTP, EMAIL, ADDRESS

012,a012_1@d.com,via_xyx

012,a012_2@d.com,via_xyx

012,a012_3@d.com,via_xyx

014,a014_1@d.com,via_xyx

014,a014_2@d.com,via_xyx

016,a016_1@d.com,via_xyx

018,a018_1@d.com,via_xyx

018,a018_2@d.com,via_xyx];

tab2:

NoConcatenate

LOAD *,

if(CTP = Previous(CTP), Peek('ID_COUNTER') + 1, 1) as ID_COUNTER

Resident tab1;

DROP Table tab1;

Regards,

Som