AnsweredAssumed Answered

Dealing with data (Pulldata) on related tables

Question asked by siewwei.goh on Nov 23, 2017
Latest reply on Apr 26, 2018 by dougbrowning

Hi,

I am seeking advice or ideas on how to deal with dataset from asset that has multiple entries under the same field attribute. For example, in one particular bridge, it contains 3 parts in span material and structure. I am not sure what is the best way to display each of these information on Survey123 (prepopulate fields) given that they have the same fieldname. These data would be stored as related tables from the source database.

 

FIELD_ATTRIBUTEA1A2 (start km)A3 (end km)
STATUS_OF_BRIDGEINSERVICE - MAINTAINED169.61169.742
SPANTYPEMATERIALBMS169.61169.677
SPANTYPEMATERIALSTEEL169.677169.695
SPANTYPEMATERIALBMS169.695169.742
SPANTYPESTRUCTUREARCH169.61169.677
SPANTYPESTRUCTUREINVERTEDTRUSS169.677169.695
SPANTYPESTRUCTUREARCH169.695169.742

 

I could rename these fields by adding numbers to the end to make the repeats unique, but that would placed them at separate columns, instead of writing back to the same field attribute/column.

 

Any suggestions will be appreciated.

 

Regards

SW

Outcomes