Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

Case 928 How to Recode long number into short number ?

Hi All

Below are my raw data from SAP :-

SeriesSeriesNameDocNum
14SFA1,971,000,182
14SFA1,971,000,182
14SFA1,971,000,182
14SFA1,971,000,238
14SFA1,971,000,238
14SFA1,971,000,238
14SFA1,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

1 Solution

Accepted Solutions
tresesco
MVP
MVP

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

Load   ....,

            Autonumber(DocNum) as NewDocNum

 

View solution in original post

2 Replies
tresesco
MVP
MVP

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

Load   ....,

            Autonumber(DocNum) as NewDocNum

 

View solution in original post

paulyeo11
Master
Master
Author

Hi Sir

Thank you 

Paul