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