Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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