This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Below are my raw data from SAP :-
Below is my load script :-
Directory;LOAD Series,SeriesName,DocNumFROMQUOT_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 ?
If your DocNum is sorted (if not sort them in asc order) and use autonumber(), like:
Autonumber(DocNum) as NewDocNum
View solution in original post