Hi,

I am running summary statistics in model builder on a table in which the statistics field is a parameter entered by the user (I am using the MAX function on this field). I then need to join the output of summary statistics to the input table (using the calculated statistic as the join field), and then use Copy Rows to export the join to a new table.

How do I know what the join field name is for the output of summary statistics?

Edit: I am using 9.3.1 if that matters.

I am running summary statistics in model builder on a table in which the statistics field is a parameter entered by the user (I am using the MAX function on this field). I then need to join the output of summary statistics to the input table (using the calculated statistic as the join field), and then use Copy Rows to export the join to a new table.

How do I know what the join field name is for the output of summary statistics?

Edit: I am using 9.3.1 if that matters.

as the join field name should not change with different statistics, it would be the same as the case field.

The Calculate Value tool is the way to calculate the output statistic name, you enter a python expression to calculate the field name, and set the output data type to Field. An example expression would be:

"%Statistic%_%Input field%"

where Statistic and Input field are elements in the model.