Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start Free Trial

Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

ReconBen
Asteroide
Saqueador
ReconBen_105.PNG

MUHAMMED_NABEEL_P
Asteroide

Nice challenge..

TheOC
16 - Nebula
16 - Nebula

Quite a fun one - and nice to reinforce some knowledge on troubleshooting issues!

Saqueador
step 1:
Load the workflow, and see whats wrong:
TheOC_0-1633705023104.png


Its clear the macro hasn't been exported with the workflow.

Step 2:
download the macro, and implement into the workflow:

TheOC_1-1633705096811.png



Step 3:
change parts of the configuration to match what is in the XML of the broken macro:

TheOC_2-1633705131653.png

TheOC_3-1633705197418.png



Step 4:
Delete broken macro, and replace connections:

TheOC_4-1633705223828.png

 

TheOC_5-1633705237199.png


Step 5:
Run and make sure it works fine:

TheOC_6-1633705541913.png


Step 6:
saving the workflow.
Save the workflow to the desktop:

TheOC_7-1633705611518.png

 


Export the workflow:

TheOC_8-1633705623870.png

Ensuring the macro is selected:

TheOC_9-1633705639901.png

 


All done!


Cheers,
TheOC
Connect with me:
LinkedIn Bulien
binay2448
Bólide

Find attached my solution for the same...

Chantelb
Cometa
Saqueador
Used Alteryx to find and edit the workflow .xml to the correct path and then write out the corrected workflow.
Chantelb_0-1635311105211.png

 

MattBenj
Bola de fogo

I'm book marking this for future macro troubleshooting!

DalilaSalinas
Asteroide

done

Watermark
12 - Quasar
12 - Quasar
Saqueador
MT Solution 105.png

leozhang2work
Bola de fogo
Saqueador
105.png

The macro itself runs, so it's not the problem. Just saved the macro to my macro folder and load in to replace the missing one, save the workflow as a packaged workflow.

The value can be obtained from the configure window.

TonyAndriani
Cometa

Reposting under my new user ID.