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?

 

 

[SGolnik]

Sometimes the AMP engine can cause this to occur, but when using the sharepoint tool you can't go without AMP. One way to try to fix this is to copy the headers that appear in the data after the cross tab and put a header row only into a text input and union it before the formula tool.