Macros

Question

Hello Team,

I am trying to create a batch macro to perform similar tasks for all values of a field but encountering issues.

PFA .

For example we have 3 categories in Superstore dataset and i need to filter them one by one and perform similar set of activities using macro.

Was trying but getting an error.

Thanks

BatchMacro2.yxmd

BatchMacro.yxmc

Qiu · Answer

@arvindjha2051 
I have never tried batch or iterative macro with in-DB connection.
I though, can undertand alteryx would try to prevent such operation since the the DB will be updated for every run, which perhaps not the best thing to happen.

arvindjha2051 · Answer

Thanks a lot.

What to do if we have in-db connection?

Because it gives an error it can be used only with standard macro

Qiu · Answer

@arvindjha2051 
Since the input file sample was not attached, I can only imagine and I blieve we should check a few point as below.

* The Operand should be selected to Update the category name
* There are no variables depending on the Category, meaning there is no meaning with a Batch Macro.
* Data Type for "Test" Column shall be numeric, such as "Double"
* Since the Category name will be control meter, we better put a Unique tool before i anchor.

BatchMacro-r1.yxzp