Macros

[arvindjha2051]

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

[Qiu]

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

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

[arvindjha2051]

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]

@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.