AutoNumber(Rowno(),"Field Name") - Confusing result

GaryMcDonald — Fri, 10 Dec 2021 21:09:00 GMT

Hello,

I'm trying to create multiple ranks using the script: AutoNumber(Rowno(),"Quote Number") as Rank1

This works on the main table as expected, however when I create a secondary table using a resident load and apply the same script (AutoNumber(Rowno(),"Quote Number")) as Rank2 but include a where clause "Claim limit Filter 2k" =1. The number doesn't start from 1 it carry's on from Rank1?

I want to create 5 ranks based on the Limit filters.

Please could someone help in explaining why the result is a continuation and how I go about resetting it so each rank starts at 1?

Many thanks Gary

Data fields:

"UniqueID",
"Quote Number",
"Retail Price Pay Annually",,
"Claim limit Filter 1K",
"Claim limit Filter 2k",
"Claim limit Filter 3K",
"Claim limit Filter 4k",
"Claim limit Filter 5K",
"CL Filter 10k",

Exampl Date:

The below image is a snap shot of the result there are 141 rows.

Re: AutoNumber(Rowno(),"Field Name") - Confusing result

sunny_talwar — Fri, 11 Jun 2021 16:12:21 GMT

AutoNumber keeps the same number based on Quote Number even if you use it in multiple tables. Try this

AutoNumber(RowNo(), "Quote Number"&1) as Rank1

and then this

AutoNumber(RowNo(), "Quote Number"&2) as Rank2

topic AutoNumber(Rowno(),"Field Name") - Confusing result in Connectivity & Data Prep

AutoNumber(Rowno(),"Field Name") - Confusing result

Re: AutoNumber(Rowno(),"Field Name") - Confusing result