topic Get 3 attributes into 1attribute column in final data model in ArcGIS Survey123 Questions

Get 3 attributes into 1attribute column in final data model

dwold — Tue, 30 May 2023 19:18:24 GMT

I have three attribute fields and I am trying to populate them into one field in the final data model. The goal is to clean up the export table from 3 columns to one when I am collecting the same information for all three entries. However, they are being captured differently in the survey. One is an integer value input and the other 2 are calculated fields.

I'd like to get : target_value_numeric, calculated_target_value, calculated_unemployed_target_value to one field say final_target_value

What is the best process to do so?

Re: Get 3 attributes into 1attribute column in final data model

IsmaelChivite — Wed, 31 May 2023 15:45:29 GMT

A few things that may help:

You can use the concat() function to concatenate multiple strings/numbers together. For example:

concat(${textQuestion}, " ", ${calculateQuestion}, " ", ${integerQuestion})

Note question types do not need a value in the name column. Keep the name empty in your note question and you will save a field in the feature layer. If you have published the survey already, the field will remain, but you can delete the field.

If you set the value of bind::esriFieldType to null, your question will not have a corresponding field in the feature layer when you publish the survey. Again, if you have published your survey already, it is too late to set this value, but you could remove the field from your layer.

The coalesce() function may be useful too. It takes two values and returns the first one that is not empty.

coalesce(${question1},${question2})

coalesce(${question1},coalesce($question2},${question3}))

Re: Get 3 attributes into 1attribute column in final data model

dwold — Thu, 01 Jun 2023 13:24:03 GMT

@IsmaelChivite the coalesce function worked perfectly! Thank you for the tip, I greatly appreciate it!