I have a list of 250 feature classes (X1, X2 X3, ...) which all have an individual field that I want to join to another feature class Y. The join can be established through a common field that are both present in Xx and Y. Individually I can use the 'join field' tool to join each Xx field to the Y feature class but this will take me a long time. Is there a way I can batch 'join field' where I use wildcards within the join field settings? Preferably I would like to do this in ModelBuilder, unless someone knows a working python script.
Within ModelBuilder I have tried to use the batch 'join field' tool and an iterator. This did not do the job as the list of values (Join field as list of parameters) did not recognize the joins.
I have attached a picture which might clarify my problem. The issue is that I cannot edit the input join Field column as it gets this list from a geodatabase through an iterator.