Field calculate a table name into a field.

Question

I am trying to create a Year Field so I can combine multiple datasets into one then filter them by year.  The individual datasets only have the year in their name(example: table_2019).  Does anyone know how I can bring the name of the table in as a value in field calculator?

Carlos_Par · Answer

Thank you @JohannesLindner  I will try that.

JohannesLindner · Answer

AFAIK, it's not possible to get the name of the table in the Calculate Field tool. But you can throw together a litte script where you get the year from the table name and then use that to calculate a new field:

arcpy.env.workspace = "G:/ArcGIS/.../my_database.gdb"
datasets = ["TestPoints_2019", "TestPoints_2020"]
for ds in datasets:
    year = ds.split("_")[-1]
    arcpy.management.CalculateField(ds, "Year", year, "PYTHON3")