Iterative or Batch Macro Help

[Mike_at_CG]

Hi Alteryx Community

Is there a way to send the below workflow into the beginning of an iterative or batch macro?

I've attached a screenshot with the workflow prior to the macro part and then a 2nd attachment with the macro input put onto the canvas.  It almost seems like input macro tool is a starting point when in reality the select tool is the starting point before the macro input.

Thank you for any help you can provide as I have never created a macro before.  Obviously! :)

[Mike_at_CG]

@davidskaife 

I've tried updating to both of the below but nothing seems to actually be generating on my desktop

C:\Users\MyName\OneDrive - MyCompany\Desktop\Contract_1.xlsx|||Sheet1

C:\Users\MyName\OneDrive - MyCompany\Desktop\

Any advice?  You've been very patient so if I need to ask my IT team I can do that as well.

Thank you

[davidskaife]

@Mike_at_CG 

Can you usually save files to your desktop? Does it work if you save it anywhere else?

[Mike_at_CG]

@davidskaife  - I was finally able to get the macro headed in the right direction. When I run the workflow from inside the macro I am able to get the first record to produce an output as expected. I was thinking that given there are two records in the data set there would be Contract_1 and Contract_2 on the desktop.  The only thing changed within the macro itself is the place where the files are being saved.  The other issue I have is that the workflow wont run the macro without me being in the macro.  I get an error that says The Control Parameter "Control Parameter (4)" must be mapped to a field.  Any chance you could help with this?

[davidskaife · Accepted solution]

Hi @Mike_at_CG 

If you click on the Macro in the main workflow you get the configuration for the Macro appear in the left - select the Questions tab, and change the Control Parameter field to RecordID. That should resolve all the issues you're experiencing

[Mike_at_CG]

@davidskaife  - Thank you again for your help on this.  I was able to get the macro to work exactly as expected.

[davidskaife]

No problem at all, glad you got it to work!

[Mike_at_CG]

@davidskaife  - Apologies. Dont mean to both again.  I can also post this as new topic.

I told you it was working as expected when I pointed the workflow to my desktop.  That worked perfectly.

However, when I try and point it to another location and save the batch macro as another name the workflow still points the saved files back to my desktop.

I thought I was catching on for a minute and then got completely lost again.

Like I said, I can post a brand new chat, just let me know.

Thank you for your time

[Mike_at_CG]

@davidskaife  - Just now realizing that saving the batch macro to the location of the file outputs is the answer to my question.  Only having the batch macro saved to my desktop and thinking I can point the output somewhere else appears to be completely wrong. Apologies for the hassle here.  Thank you for all the help