Columns Created by Crosstab Result in "Unknown Variable" Error

[dmccarville4]

I have a workflow which fundamentally operates like this:

• Data is downloaded from an API.
• The resulting JSON is cleaned into a tabular format.
• The cleaned data is "tall". There are essentially three columns: record_id, column_name, and column_value. I use crosstab to turn this into "wide" data.
• A formula creates some new calculated columns.

The column names used in the Formula block don't exist until after the Crosstab block. This works just fine locally, but when running in the Gallery Alteryx can't seem to resolve this. Errors attached.

Locally, these errors don't appear. I've tried several things to resolve this:

--- Running the workflow locally than re-saving to Gallery.

--- Deleting the Crosstab, recreating it, then re-saving to Gallery.

--- Deleting the older versions out of Gallery and then re-saving.

--- Deleting the connectors around the Crosstab and Formula, then re-building.

But no results. Is there something I'm missing?

  

[nagakavyasri]

@dmccarville4 There should be a problem with data coming to Cross tab tool. In this case, may be no/few columns are missing at the Cross tab output and so you are getting error in Formula tool. Check if the input is fetched in Gallery and the workflow running till cross tab tool is generating any output.