topic Re: Autonumber for New Item in QlikView

Autonumber for New Item

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi! I am hoping someone can help me on this...

I have a script below which I want to number by OrderNo...but it's not what I expected ... I'd like to have an output based on the table as below highlighted in yellow.

Order:
load*,

autonumberhash128([OrderNo) as Sequence

Resident Order
order by [OrderNo];
Drop table Order;

Thank you in advance...

Re: Autonumber for New Item

sunny_talwar — Wed, 10 May 2017 00:00:03 GMT

Try this

Table:

LOAD * INLINE [

OrderNo

A682

A904

A913

B576

B577

B578

C588

D589

E137

];

FinalTable:

LOAD RowNo() as RowNum,

If(OrderNo = Previous(OrderNo), Peek('DesiredOutput'), RecNo()) as DesiredOutput

Resident Table

Order By OrderNo;

DROP Table Table;

Re: Autonumber for New Item

Anonymous — Wed, 10 May 2017 20:12:55 GMT

Hi: Sunny,

It worked... I just need to take out the ' ' in Peek('DesiredOutput') and make as Peek([Desired Output]) ...

Thank you much...

Re: Autonumber for New Item

Anonymous — Wed, 10 May 2017 20:19:36 GMT

peek() works with single quotes!

Re: Autonumber for New Item

Anonymous — Wed, 10 May 2017 21:29:35 GMT

HI! It reloads successfully but there are missing numbers with the single quotes.

Re: Autonumber for New Item

sunny_talwar — Thu, 11 May 2017 00:34:25 GMT

That is because you named your column as Desired Output with a space.... mine was without space

FinalTable:

LOAD RowNo() as RowNum,

If(OrderNo = Previous(OrderNo), Peek('DesiredOutput'), RecNo()) as DesiredOutput

Resident Table

Order By OrderNo;

DROP Table Table;

Anyways, I encourage you to open the attached file to check out the app to see that it was actually working in there

Re: Autonumber for New Item

Anonymous — Thu, 11 May 2017 21:09:37 GMT

I actually did open it and that's when I realized it must have something to do with the space....

Re: Autonumber for New Item

sunny_talwar — Thu, 11 May 2017 21:33:22 GMT

Great.... I am glad it helped you...