Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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!

geoff_zath
Alteryx
Alteryx

Found the original API key but it doesn't appear to work? Stuck with the demo key.

Spoiler

geoff_zath_0-1685647664435.png

 

SylwiaDragon
8 - Asteroid

I have inserted the macro to the canvas, and then exported workflow with all it's assets.

tristank
11 - Bolide

Pretty reasonable challenge. Put in a new macro and originally changed it to UNC path until I looked at solutions and realized that relative would make more sense based on the info we had. Changed it to relative and exported it as a packaged workflow. Had no idea how to tackle the bonus ask so it was cool to see the users messing with the XML to keep everything the same (something I'm not yet very familiar with but I should get try to get more comfortable doing)

 

Spoiler
Screenshot 2023-07-27 191411.png

 

mithily
8 - Asteroid
Spoiler
EDITED THE MACRO PATH IN THE XML AND IT SHOWED ANOTHER WAY IS TO MOVE THE MACRO TO THE USER SETTINGS MACRO FOLDER AND THEN INSERT THE MACRO; DELETE THE OLD MACRO WITH THE ? AND WIRE UP THE MACRO AND YOU SEE THE PICTURE. i ALSO EXPORTED THE WORKFLOW THIS TIME SO THE MACRO IS PACKAGED WITH IT
bo_peng2022
8 - Asteroid

My solution

ed_hayter
12 - Quasar
Spoiler
Interesting debugging case. Redragged in the macro from an alternative location rather than the macro repository.

Perhaps not the best way of doing things.
Challenge 105 WF Image.png
gawa
16 - Nebula
16 - Nebula

Done

Spoiler
image.png
Tokimatsu
12 - Quasar

Done

Spoiler
Open Reporting_Workflow.yxmd by notepad. Find "AstronomyPictureOfTheDay.yxmc". Edit the path.

スクリーンショット 2023-09-21 171557.png

Hammad_Rashid
11 - Bolide

DataAnalyst23_0-1701243437432.png

 

Rob-Silk
8 - Asteroid

Solution(s) outlined below:

 

Spoiler
Two methods that I can think of to achieve this

1. Most direct method seems to be to update the broken macro path in the main workflow XML - the workflow expects to find the macro in a "Macros" sub-folder relative to the main workflow path

Open the workflow file in a text editor (I prefer VSC for this sort of thing), find the offending line and update to point to the path where  the provided macro is saved, save the main workflow and re-open in Designer.
challenge_105c_RS_screencap.PNG
(Note - if you save the main workflow with a broken macro path reference, then the broken link will be lost from the XML file next time you try this trick and you get an empty <EngineSettings /> tag instead)
challenge_105d_RS_screencap.PNG


2. Alternatively, use the provided macro file to insert a new copy onto the main workflow canvas, then access the XML settings of the original (broken link) macro tool and replace the new tools settings with these using the XML editor

challenge_105a_RS_screencap.PNGchallenge_105b_RS_screencap.PNG


3. Having fixed the workflow with a working macro, make sure to set all dependents to use relative paths and then export the workflow with the "relative-path" macro as a .yxzp file so that the next person doesn't have the same issue.

challenge_105e_RS_screencap.PNGchallenge_105f_RS_screencap.PNG