topic Re: Increment ID in Load Script in QlikView

Increment ID in Load Script

jduluc12 — Sun, 25 Dec 2016 00:17:54 GMT

HI,

I have a table in QVD.

ID Value

1 abc

2 efg

3 bhu

Now when i load it then i need to start the ID with a different number and then keep incrementing it till the end.

so the output should look like if I decide to start the ID with 34

ID Value

34 abc

35 efg

36 bhu

what should the load script should look like?

jayanttibhe — Sun, 25 Dec 2016 04:25:26 GMT

Hi Jean,

See attached QVW : OR something like this :

T1:

Load RecNo()+33 as NEW_ID

;

LOAD * INLINE [

ID, Value

1 , abc

2 , efg

3 , bhu

]

;

Thanks

Jayant Tibhe

vinieme12 — Sun, 25 Dec 2016 08:05:51 GMT

Or add a prompt , so you don;t have to Edit script everytime to change the value

let a = Input('Enter Value','Enter Start Value');

LOAD rangesum(autonumber(ID),$(a),-1) as NewID,Value INLINE [

ID,Value

1,10

2,20

3,30

4,40

];