So I got a dataset, floorID and Unit Number. Here is what I want to do.
For each of the floorID (meaning each floor), the unit number should start from 0001 to the max number in sequence. For instance, in my example, there are 4 floor ID "level1", the unit should be 0001-0004. In contrast, there are 3 floor ID "level2", so the unit should be 0001-0003.
In my case, the input of floorID and unit number is unknown. But I want to find out the missing unit numbers or wrong input unit numbers.
Could someone guide me how to work in this case?
I have attached the correct and wrong output in here.
Oh, also, I have another question. This is the sample of the data
1-1, 1-2, 1-3
2-1, 2-2
If I want to see if the incoming input is within this value, might I ask what kind of transformer should I use? Do I need to input these values manually?
Thank you very much and sorry for all the questions.
Zach