run batch macro for each list box element

Hello, I am having trouble since yesterday to make a workflow that to me sounds trivial, maybe just because I'm used to Python programming.

basically, the final user has to select from a List Box Tool one or more elements, then I need, FOR EACH ELEMENT, to place it in a Filter Tool (filter out of a dataset only records that contain the element) and then perform other operations on this filtered dabaset (like Summarize, Formula and Report).

I am trying to do this with a batch macro, using the list as the control parameter, but I can't get it to work, no matter how I try.

Please someone help me, I'm close to trash the whole workflow and just do it on Python lol

ps. sorry for not attaching any file but I'm working with sensible data

Batch Macro

Accepted answers

afv2688

Hello @MassimoDM,

you can use this to pass the elements to a batch macro one by one:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

pass data.yxzp

All comments

afv2688

Hello @MassimoDM,

you can use this to pass the elements to a batch macro one by one:

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Regards

pass data.yxzp

MassimoDM

thank you so much!

I was just missing the Text to Columns Tool. I was passing to the macro the Text Input tool directly, without realizing it was just plain text and wasn't read as I expected. Adding the Text to Columns really did the trick, thank you again

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335