Skip to main content
  • EN

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

Split off the records with a null value for SampleID (TestFilter) and then use a FeatureMerger or FeatureJoiner to join them back to the other records.

Worked perfectly, thank you

Reply


Community Stats

30,179
Posts
114,557
Replies
37,844
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.