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.
