Hello,
I have created a workspace to download attachments from Survey123 for ArcGIS which works perfectly, apart from one thing. Some of the attachments are stored in related tables and as a result don't pull have the sample ID field included and this is causing issues further down the workflow.
I need to create a workflow that compares the parent ID field against the whole globalID column. If it finds a match, then it copies the sample ID field to the appropriate line and replaces the NULL field.
Does anyone know how to do this?
GlobalIDParentIDSampleID1234NULLSamp 14564NULLSamp 2548441234NULL54564844564NULL45848545NULLNULL
