I have created macro for my workflow but macro not working

I have tried to create macro on my workflow when i created a macro and using it on another flow it is giving a error message this tool required a control unit. But when i select dropdown i am not getting anything in dropdown. i have attached the workflow and macro using flow.

Clean_data.yxmc

macro_try.yxmd

Accepted answers

All comments

jdminton

I can't see your data, but the macro is set to a batch macro. This would require a control parameter tool. Since that isn't there, you are likely just performing a standard macro. Change the setting in your workflow settings (for the macro itself) from batch to standard and see if that fixes it.

jdminton

@Lokesh22 did this resolves your issue?

Lokesh22

jdminton No Not yet same issue with standard macro

jdminton

Can you provide some sample data to run through? The Macro references a file that you did not include.

Lokesh22

@jdminton sure i will send the log file and i want to process multiple files one by one. can you please share your mail id because .log files can not uploaded here.

jdminton

There are a couple of ways to do this. 1) change the extension to .txt or .csv or 2) go to your menu in the workflow (in Alteryx Designer) and select options and export workflow. This will create an Alteryx package that will contain workflow and the input file and macro.

Lokesh22

@jdminton i am reading as .txt file, it works for one file but want for multiple files to run and get output.So want to use macro.

Amit_G_Limbasia

Dear @Lokesh22,

I have go through the workflow and Macro I have found that you use column name which is statics as that might be change in every batch part or It is not that dynamic which give desired results. So if you provide log workflow attached with log files in zip I can try and give better solution.

Thanks

Enjoy Solving!

jdminton

@Lokesh22 , I was meaning that you can attach them here if you change the extension to .txt. You can do that versus needing my email to send it to me. Or you can package the workflow as instructed above so we can determine what in your workflow needs fixed.

jdminton

@Lokesh22 I haven't heard anything back yet. Were you able to resolve yourself?

Lokesh22

@jdminton and @Amit_G_Limbasia sure i have send some .log file but as .log was not supported, so i changed extension to .txt. sorry for delaying the response. Thanks for help in advanced.

5b3aeaf6885711eda7780225a990f764.txt

85a4ea02892011eda7780225a990f764.txt

55125ca0878e11eda7780225a990f764.txt

b010224c89e911eda7780225a990f764.txt

da785be88ab211eda7780225a990f764.txt

jdminton

@Lokesh22 There were a few things that needed changed, but the reason you had that specific error is that it was set to a batch macro and you didn't need a batch macro. A standard macro works fine. You might still need to play with your parsing in the macro to get it correct, but I've got it working. Please mark as solved once you confirm. Thanks!

macro_try.yxzp

Clean_data.yxmc

jdminton

@Lokesh22 were you able to test this?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703