Question

How to find a missing value in a range of data

  • 15 November 2021
  • 1 reply
  • 6 views
Z
Badge

Hello, so I want to find a missing value as all the "Unit" must be in sequence in each floor.

​

Here are my rules:

All the units should be assigned sequentially to the corresponding floor, meaning

1/F: Unit = 0001, 0002, 0003, till to the largest number in the data

2/F: Unit = 0001, 0002, 0003, till to the largest number in the data

​

I have "FloorNo_FromFloorPolyID", meaning the level of floors.

"Test_Unit_No" meaning the numbering of the unit.

​

I want to find out the missing unit number of each floor as the input data will have a lot of floors in the future.

 

As the sample shown below, Floor 10 is missing Unit 0001 to 0004.

​

Could someone please give me a hand. Should I use python caller? Yet I have no clue how to write script ... please help.

​

Thank you in advanced.

1 Attachment

1 reply

jkr_wrk
Rank
Userlevel 3
Badge +18

Could you merge all possible floor numbers to all floors, creating a dataset of all the combinations you want?

 

Then merge all the wanted combinations to existing combinations?

Sample: Every Nth Feature (N=1)

Reply


Community Stats

28,724
Posts
109,519
Replies
36,564
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.