topic Re: Subtype/Asset group lookups using Data Loading Workspace tools in Data Loading Tools Questions

Subtype/Asset group lookups using Data Loading Workspace tools

RichMoore — Fri, 18 Dec 2020 15:20:21 GMT

---

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

Source feature class	Subtype	Description	Target feature class	Asset group
NetworkStructure	6	Gate	SewerDevice	27
NetworkStructure	1	Discharge	SewerDevice	22
NetworkStructure	7	Weir	SewerDevice	26

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

SourceDefinitionQuery

subtype 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

Re: Subtype/Asset group lookups using Data Loading Workspace tools

AllysonReynolds — Tue, 05 Jan 2021 13:52:00 GMT

Rich,

As far as I understand it, yes you will need a different row for each asset group in the DataReference workbook. I've truncated the entire path name here so it would fit in the image, but it's like this:

From that image, you can see that for each of those rows, a different MappingWorkbook also needs to exist. Though, those are generally pretty much the same, at least for me, so far.

Re: Subtype/Asset group lookups using Data Loading Workspace tools

AllysonReynolds — Tue, 05 Jan 2021 13:52:59 GMT

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

Re: Subtype/Asset group lookups using Data Loading Workspace tools

RichMoore — Tue, 05 Jan 2021 14:32:16 GMT

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

Re: Subtype/Asset group lookups using Data Loading Workspace tools

AllysonReynolds — Tue, 05 Jan 2021 14:35:02 GMT

Rich,

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

-Ally