Case 928 How to Recode long number into short number ?

[paulyeo11]

Hi All

Below are my raw data from SAP :-

Series	SeriesName	DocNum
14	SFA	1,971,000,182
14	SFA	1,971,000,182
14	SFA	1,971,000,182
14	SFA	1,971,000,238
14	SFA	1,971,000,238
14	SFA	1,971,000,238
14	SFA	1,971,000,238

Below is my load script :-

Directory;
LOAD Series,
SeriesName,
DocNum
FROM
QUOT_SD_.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

May i know how to auto recode the long number into 1 to 2 ?

1,971,000,182=1

1,971,000,238=2

Paul Yeo

[tresesco · Accepted solution]

If your DocNum is sorted (if not sort them in asc order) and use autonumber(), like:

Load   ....,

            Autonumber(DocNum) as NewDocNum

[paulyeo11]

Hi Sir

Thank you 

Paul