Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
If your DocNum is sorted (if not sort them in asc order) and use autonumber(), like:
Load ....,
Autonumber(DocNum) as NewDocNum
If your DocNum is sorted (if not sort them in asc order) and use autonumber(), like:
Load ....,
Autonumber(DocNum) as NewDocNum
Hi Sir
Thank you
Paul