topic Re: Table to Domain with Filter in Geoprocessing Questions

Table to Domain with Filter

ToddHenry1 — Thu, 16 Apr 2015 17:13:58 GMT

I have a table with a list of employees that I would like to split into three separate domains based on their job description which are listed in the table. Is there a way (probably with python) to automate the creation of those domains so that I could use the Table to Domain tool, but with only the appropriate subset.

Right now, I'm using the Create Domain and AddCodedValueToDomain to do this manually for each person.

Thanks.

Re: Table to Domain with Filter

OwenEarley — Thu, 16 Apr 2015 21:19:39 GMT

I would use the Make Table View tool with an expression to select your users into groups - then use the Table to Domain tool to create the domains.

Re: Table to Domain with Filter

OwenEarley — Sun, 12 Dec 2021 02:42:19 GMT

Something like this should work:

import arcpy

# script parameters: 
userTable = r"G:/Temp/GeoNet/TableToDomain/Users.gdb/Users"
domainTargetGdb = r"G:/Temp/GeoNet/TableToDomain/Users.gdb"

# Create Admins Domain
admins = arcpy.MakeTableView_management(userTable,"Admins",""""GroupName" = 'Editor'""")
arcpy.TableToDomain_management("Admins","Username","Username",domainTargetGdb,"Admins","Admin Users","REPLACE")

# Create Editors Domain
editors = arcpy.MakeTableView_management(userTable,"Editors",""""GroupName" = 'Editor'""")
arcpy.TableToDomain_management("Editors","Username","Username",domainTargetGdb,"Editors","Editor Users","REPLACE")

# Create Viewers Domain
viewers = arcpy.MakeTableView_management(userTable,"Viewers",""""GroupName" = 'Viewer'""")
arcpy.TableToDomain_management("Viewers","Username","Username",domainTargetGdb,"Viewers","Viewer Users","REPLACE")

You will need to change the source of the users table and the target geodatabase as well as the query expressions used to select your user groups in the Make Table View tool.

Re: Table to Domain with Filter

ToddHenry1 — Fri, 17 Apr 2015 17:38:00 GMT

Thanks. That makes a lot of sense.