Crosstab tool forgets its configuration

[Newt]

I'm using two Crosstab tools in sequence, to untangle a very long string downloaded from the US Climate archive.

I put in the groupings and the columns to use, run successfully, save workflow.

Come back to it, and either the second crosstab tool or both of them have forgotten the groupings and the columns to use.

When I come back to it, I have to run it twice.  At the start, the second crosstab doesn't have the needed field names in the "Group data by" box nor in the two Change Columns and Values For boxes.  Only after running it once to get these to come through first Crosstab are the field names available to select in the second Crosstab, so I can run it successfully a second time.

I don't know if this is because in the workflow, there is no original input file with field names... just the mashup downloaded cell full of data.

Does anyone else have this problem?

[MeganBowers]

@Newt It seems like the issue is that the filter tool does not have the metadata of the fields after the first cross tab tool, so it does not recognize "datatype" until after the workflow is run (hence the error below upon opening the workflow).  

 

I tried adding a select tool in between to help with this, so the filter tool has metadata of what fields are coming in before the workflow is run, and it solved the errors on my end. I saved and closed the workflow, and then opened it back up and it ran without the second cross tab needing to be reconfigured.

Can you try this on your end and see if it works?