Weekly Challenges

TonyA · ‎06-04-2019

Solution attached.

The initial error message said the workflow was looking for a macro in .\macro\...
So I created a folder called macro in the same folder as the workflow and put the yxmc file in that folder. Every thing worked with the original configuration.

The initial error message said the workflow was looking for a macro in .\macro\...So I created a folder called macro in the same folder as the workflow and put the yxmc file in that folder. Every thing worked with the original configuration.

RWvanLeeuwen · ‎08-08-2019

Super fast challenge by the way!

My method without an image:

Spoiler

Download workflow and macro.

Open workflow and add macro again via right click, insert macro.

Replace the broken with the macro and fix the connections manually. (Run workflow as a test)

Go to Options, Advanced Options, Workflow Dependencies, and set to All Relative

Save and Export the workflow

Download workflow and macro.Open workflow and add macro again via right click, insert macro.Replace the broken with the macro and fix the connections manually. (Run workflow as a test)Go to Options, Advanced Options, Workflow Dependencies, and set to All RelativeSave and Export the workflow

PaulN · ‎08-11-2019

Open yxmd file in Notepad and look for the reference to the yxmc file then update the path.

SophiaF · ‎08-12-2019

Do non-Alteryx solutions count?

Spoiler

Sophia Fraticelli
Senior Solutions Architect
Alteryx, Inc.

cgoodman3 · ‎08-31-2019

Spoiler

The issue was the macro wasn't being correctly located as it is saved in another directory, therefore bringing the macro in again and copying the settings from the XML of the original macro worked.

Challenge 105.PNG

The issue was the macro wasn't being correctly located as it is saved in another directory, therefore bringing the macro in again and copying the settings from the XML of the original macro worked.

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com

OllieClarke · ‎09-12-2019

Here's how I did it:

Spoiler

arjanloogman · ‎10-08-2019

Did the same as TonyA:

Saw the error, created 'macro' folder and moved the .yxmc in there. Opened the workflow again and woosh!

No nifty notepad stuff here...

T_Willins · ‎10-08-2019

Spoiler

My first thought was to just reinsert the macro and fix the inputs, which worked but seemed to easy for this challenge. Researching the community I found information about correcting the path directly in the workflow XML. First attempt - opened in Notepad (not Notepad++). Second attempt: opened in Notepad ++, but couldn't figure out where I should fix it. I reviewed some of the other posted solutions then found my way. I added just the macro to a new workflow and saved it, which gave the name in the correct format to copy and paste into the original workflow. Great to learn this as it is a handy way to fix broken Alteryx macros (reason #7859523 why Alteryx macros are better than Excel macros).

corrected workflow 105.JPG

My first thought was to just reinsert the macro and fix the inputs, which worked but seemed to easy for this challenge. Researching the community I found information about correcting the path directly in the workflow XML. First attempt - opened in Notepad (not Notepad++). Second attempt: opened in Notepad ++, but couldn't figure out where I should fix it. I reviewed some of the other posted solutions then found my way. I added just the macro to a new workflow and saved it, which gave the name in the correct format to copy and paste into the original workflow. Great to learn this as it is a handy way to fix broken Alteryx macros (reason #7859523 why Alteryx macros are better than Excel macros).

dsmdavid · ‎10-28-2019

Can finally attach files*, although cannot edit my previous reply

* Not apps or packaged workflows though

KMiller · ‎12-17-2019

Solution attached.

Spoiler

Weekly Challenges

IDEAS WANTED

Challenge #105: Think Like a CSE… Tools are missing!