Skip to main content
  • EN

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.

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?

Reply


Community Stats

30,176
Posts
114,542
Replies
37,835
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.