Active Flag sheet now showing in Data Reference table during data loading

[TristanBest]

Hello, I am going through the process of setting up a utility network following the load data into a utility network instructions (https://learn.arcgis.com/en/projects/load-data-into-a-utility-network/#begin-simple-data-mappings) 

After I create the migration workspace using my own local data, I do not get the ACTIVE FLAG sheet in the 'mapping workbooks' created in the DataReference table.

However whenever I first went through this process using the dummy data, the ACTIVE FLAG sheet populated. So, I'm not sure where I went wrong when doing it using my local data.

Any ideas why this could have happened?

[gis_KIWI4 · Accepted solution]

@TristanBest  - Don't think there is anything necessarily wrong here. 
You are seeing the ACTIVEFLAG when you use the provided dataset because it is a field in that dataset.
You own local data might have that field called something else. You can use that field for mapping to the Lifecycle status following the same steps in the tutorial. 

[RobertKrisher]

@gis_KIWI4 is correct. The data reference/mapping sheets generated by the tools are unique to your data. The tables, fields, and domains are based on your data, not the local government model used in the tutorial.

[TristanBest]

Ah I see, so I will need to create my own sheet in my mapping workbooks for setting the LookupSheet,Keys,Value,Etc for mapping the domain values for field expression conversions.

[RobertKrisher]

@TristanBest The tool will create the sheet based on your current model, and your job is to fill out the lookupsheet, keys, etc to show the tools how to translate your current data model to the target data model.

[TristanBest]

Hmm, I've tried a couple of times now but when I create the data reference table, the supporting mapping workbooks do not create the sheets. Not sure what I'm missing to cause this.

[RobertKrisher]

@TristanBest what Worksheets or Workbooks are you expecting to see that aren't being created? The additional tabs (worksheets) in each workbook (file) are based on the domains in your source data. If your source data doesn't have any domains, then you won't get any by default. If you need to do translation you can always use the global mapping sheet, or create your own worksheets from scratch to do the translation.

[TristanBest]

Robert, that sounds like my problem. I had created a testing geodatabase and copied my water data into it. I didn't think about the domain values not coming over as well. Thanks for the the help!

[RobertKrisher]

@TristanBest if you use copy/paste or the copy geoprocessing tool to copy your data into the file geodatabase it will preserve your subtypes and domains.