Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Batch Macro Improperly Configuring

MatthewR09
5 - Atom
I am trying to write a simple Batch Macro that changes the Filter Value of a data set and runs a specific workflow for each Filtered Value. The issue arises when I am trying to Input data and Alteryx tries to configure the fields under the Questions table of the Macro. The Input file and the Macro Input are the exact same file. I have also tried to uncheck the Show Field Map box but it did not work. It appears the wrong fields are being mapped even though they do not have the save Column heading. It is also only occurring through the columns that have the word "Severity". For example, 'AM IRSeverity' is being matched to 'AM IR', even though there is a corresponding 'AM IRSeverity'. Any ideas of what is going wrong? I cannot share my full data as it is sensitive info.
5 REPLIES 5
apathetichell
20 - Arcturus

can you share a screen shot of your action tool in your batch macro? (and perhaps the filter tool)

MatthewR09
5 - Atom

Sure, here you go. 

 

MatthewR09_0-1624392299492.png

 

apathetichell
20 - Arcturus

So for starters - change your action tool so that it's modifying the expression -value's "WM" - not the operand. Save it/close it 2 and give it a run. This is assuming you are trying to compare your filter value to WM (and WM is what's being replaced by the control parameter).... This may require putting your compare in the body of the filter - instead of the simple filter option.

 

After that  - if it doesn't work and if you have you have the questoins/input side of your batch macro set up correctly - it's going to be hard to fix without dummy data that replicates your fields (Not your data - just your fields)...

MatthewR09
5 - Atom

Thanks for the input. I've updated the Action Value but still getting the same error. Would I have to recreate the dummy data using the text input tool? I was trying to avoid that considering the amount of columns my data has

apathetichell
20 - Arcturus

you should be able to highlight  your columns and cut and past them into a text input (or directly into a message here...)... You can just create a row with random letters as data.

Labels
Top Solution Authors