Question

How to find a missing value in a range of data

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.

+35

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?

💡 Did you know... The FeatureWriter is more intuitive. 😏

1 reply