Table to Domain with Filter

Question

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.

ToddHenry1 · Answer

Thanks. That makes a lot of sense.

OwenEarley · Answer

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.

OwenEarley · Answer

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.