Subtype/Asset group lookups using Data Loading Workspace tools

Question

---

We have a source feature class with multiple Subtypes that map to the Sewer Network like this:

Source feature classSubtypeDescriptionTarget feature classAsset groupNetworkStructure6GateSewerDevice27NetworkStructure1DischargeSewerDevice22NetworkStructure7WeirSewerDevice26

I can use a query in the DataReference.xlsx to select the Subtypes I want:

SourceDefinitionQuerysubtype in (6,1,7)

My question is ... How do I specify the correct Asset group?

Do I need a separate row for each target Asset group in the "SourceTargetMapping" sheet in DataReference.xlsx?

Or can I create an expression that maps the Source Subtype to the Target AssetGroup in the "MappingWorkbook"?

I can get the domain table lookups to work, but I haven't figured out how to do Subtype lookups.

Thanks, Rich

AllysonReynolds · Answer

Rich,

That seems much more efficient. Thanks so much for sharing!

-Ally

RichMoore · Answer

Thanks Allyson.  I found an alternative method that does this similar to mapping domain tables.  The attached graphic might help to explain.

AllysonReynolds · Answer

Not sure if this attachment might be easier to see/read.

dataReference.PNG