Iterating fields using ModelBuilder in ArcGIS Pro

Question

I am trying to combine multiple fields using the iterate fields in ArcGIS Pro ModelBuilder. I can iterate through and get the combined values but it only gives me the combination of one row, therefore I have no way to calculate a new field with these fields merged together for all rows in the table. The main aim is to use wildcard for all columns starting with soil_type and concatenate into a new field but it always calculates the same values.
Can this be done or will it only work for updating features based on only these fields? Image shows what I want to achieve. I want to do do this once a week but the soil type fields are not consistent

Hornbydd · Answer

You do not need to use an iterator if you want to create your combined field.

Create you text field combined, make sure its long enough, so in your example a text field of 20 characters would be sufficient. Use Add Field tool to create it.
Run the Calculate field tool, your expression would be !Soil_Type1! + ", " + !soil_type2!. If you don't know what the field calculate tool is please read the help file and study it's page.

The Calculate Field tool will honour selections; so with no selection, the expression is applied to each row.

Iterating fields using ModelBuilder in ArcGIS Pro

One Answer

Add your own answers!

Ask a Question