Hi all,
I'm trying to use the Batch Macro to solve the weekly challenge #11. However my Batch Macro doesn't work for some reason. Can anyone help me to point out what's wrong with the workflow/macro?
Thanks a lot
Solved! Go to Solution.
@archietao why do you want to use a macro? The challenge can be solved without one.
Hi @yalmar_m
Thanks for your reply. I saw there are two solutions for that challenge. One has a batch macro (attached below) so I wanna figure out how it works by trying to replicate the workflow by myself. However, mine just doesn't work. And I just wanna know what went wrong.
Hi @archietao
I think I solved your problem, it appeared to be a checkmark in the Find-Replace tool.
You only replaced the case sensitive fields, resulting in no matches.
If this solves your problem, please mark it as solved.
Hey @archietao
I changed some things in your batch Macro.
Solution attached.
If you have any doubts, please do not hesitate on commenting.
Cheers,
Hi @yalmar_m
Thanks for pointing that out! really appreciate it! However, the result remains the same for some reason.
Hi @Thableaus
Thank you so much for replying! I have some trouble opening your solution though.
It says:" There was an error loading a macro..."
Hey @archietao
Since you cannot open the macro, I will try to explain briefly what I changed.
The macro does not need a macro Input. Just leave the .yxdb file as an Input Data, since it's the same file you'll use.
Add a record ID, as it'll be very useful to group the comments that contain more than one bucket.
In the Action parameters, I changed to Update Value (replace specific string), so it's more flexible.
Find and Replace tool must have the Case Insensitive Find ticked.
You just need to connect the Search & Bucket input to the Macro, then group by Record ID and concatenate the Buckets. After that, just count each bucket and you'll have the answer.
Cheers,
Hi @Thableaus
Thank you for the explanation! I also downloaded the newer version of Alteryx and now I can open your workflow. And it works.
Thanks for your help!