Here is how I would handle this scenario:
- Change name of the select_one question to "Indicator_Holding"
- Set the bind::esri:fieldType to "null". This tells survey123 to not submit data in this row.
- Change "IndicatorCollated" to "Indicator"
- Update any instances of ${Indicator} to ${Indicator_Holding}
- Results - Indicator field contains either the indicator holding or the indicator other value. no extra columns needed in the db.
You could also set IndicatorOther esri field type to null, to further clean up the database.