Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Parse Error on Formula

DrewCroft
7 - Meteor

I have a macro that uses a Formula tool.  There are two fields:

  Screenshot 2024-12-12 161449.png

 

The SubcategoryRaw field is coming from a Select tool that has it configured as a V_String 255.

 

 When I test this macro workflow, the workflow outputs perfectly with no errors.

 
 
 

 

When I attempt to use the macro in a workflow, I get errors pointing at the Formula tool expressions…

Screenshot 2024-12-12 161222.png

 What gives?

5 REPLIES 5
binuacs
21 - Polaris

@DrewCroft @Can you check the data type of subcategory field in the append tool? Also can you try running workflow after turnoff the  AMP Engine?

DrewCroft
7 - Meteor

Thanks for the response, @binuacs!  

 

Turning off the AMP Engine didn't change anything at runtime, unfortunately.  The settings for that Append tool are below:

 

Screenshot 2024-12-13 131436.png

binuacs
21 - Polaris

@DrewCroft Without seeing the macro trouble shooting is difficult, can you try to run with different input files to see there is any change. 

DrewCroft
7 - Meteor

I understand it is difficult to debug without being able to get your hands dirty with it.  Unfortunately, the data I'm working with is proprietary and I cannot post it.  

 

I do know it happens on EVERY file (there are 50+).  The macro portion works without trouble if it is standalone but if you toss that into a batch workflow, the error on the Formula pops up.  The syntax for both formula seem good, I'm not sure what's going on.  ;__;

binuacs
21 - Polaris

@DrewCroft what the action yool settings inside the macro, can you screen shot the settings here

Labels
Top Solution Authors