Identifying objects with no measure property value

This question has come up a couple of times. With the current tools, it can be a bit tricky to create a group for objects that have “No value” as the measure type of a property value. To work around this, we can create a temporary property that can be used in a group query to identify objects without a measure property value. Later in the dataflow, we can remove the temporary property if needed. The workaround is very simple.

1. First, we create a boolean property called "Height has value" in the "My Temp Properties" property set and set the default value to "No".

   

2. Next, we use the "Calculate Properties for Objects" step to set the "Height has value" property to "Yes" for objects that have a measure property value for the "Height" property.

   

3. Finally, create a group based on the temporary property that was created.