Autonumber() No Duplicates

bxprokop — Sat, 16 Nov 2024 00:51:56 GMT

I am trying to use Autonumber() to generate a number for Cost and Customer. I have sorted already sorted in the order needed but I do not want the Autonumber to repeat when multiple Customers have the same cost. How do I end up with an Autogenerated Number equal to the number of rows with no duplicates when the cost is the same. Example: If I have 4000 rows I want my ending AutoNumber to be 4000 not 3500 with duplicates. Hopefully, that makes sense. Any help will be greatly appreciated.

Re: Autonumber() No Duplicates

Frank_Hartmann — Fri, 10 Apr 2020 07:13:23 GMT

Use RowNo() instead.

Load *, RowNo() as Row, AUTONUMBER(Status) as Row1; LOAD * INLINE [ Status, Data a, 2 a, 2 b, 3 c, 4 a, 6 a, 2 ];

topic Re: Autonumber() No Duplicates in QlikView

Autonumber() No Duplicates

Re: Autonumber() No Duplicates