topic Re: Editing Survey123 data in ArcGIS Survey123 Questions

Editing Survey123 data

DanCrafton — Fri, 28 Oct 2022 12:03:56 GMT

I recently merged the data from two Survey123 surveys using the append command in ArcGIS Pro. One Survey was completed in the web designer, the other in Connect. Both surveys had the same questions, but the recorded answers are slightly different: Less-Than vs less_than. My dashboard sees these as two different answers. I know I can edit each record seperately in the data tap on the hosted feature layer. There are several thousand records that need correcting so I would like to avoid getting carpel tunnel syndrome. Is there a way to more than one record at a time?

Re: Editing Survey123 data

DanCrafton — Fri, 28 Oct 2022 12:06:50 GMT

I should add that some of the records have attachments so I dont think downloading into Excel would work.

Re: Editing Survey123 data

ZenMasterZeke — Fri, 28 Oct 2022 12:19:09 GMT

In Pro you could select the ones in the non-desired format, i.e. 'less-than' and calculate them all to 'Less-Than'

Re: Editing Survey123 data

DanCrafton — Fri, 28 Oct 2022 13:19:25 GMT

Do I do that in the attribute table for the hosted feature layer?

Re: Editing Survey123 data

DanCrafton — Fri, 28 Oct 2022 15:37:10 GMT

I figured it out, there is a Find and Replace command in the attribute table. Can replace each record one at a time or do them all an once.

Re: Editing Survey123 data

ZenMasterZeke — Fri, 28 Oct 2022 19:22:17 GMT

There's a Calculate Field tool in the attribute table, but whatever works 🙂