Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

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

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I went with using Alteryx to amend Alteryx.


Actually had this issue today whilst working on the community!

Spoiler
Workflow Image.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

 

Opened the Workflow after replacing the Marco in Notepad and copyied the origninal marco code into the workflow.

 

Challenge_105_.png

Highlighted
Alteryx Certified Partner

 

Spoiler
As stated in the error message, we have to :
Create a folder named "Macro" in current directory a.k.a. next to the "Reporting_Workflow.yxmd" file. Inside the "Macro" folder, we put "AstronomyPictureOfTheDay.yxmc" and issue fixed 🙂 Please see attached: the generated PDF report.

As of the original values, if I understood the issue correctly, just open the files with a text editor to appreciate the XML structure and get the following :
<Data>
<r>
<c>https://api.nasa.gov/planetary/apod</c>
<c>today</c>
<c>False</c>
<c>DEMO_KEY</c>
</r>
</Data>

[105 - Resolved]

 

Highlighted
Alteryx
Alteryx

Hello everyone! A video solution has been posted to the original post (inside the spoiler tag)!

 

https://community.alteryx.com/t5/Weekly-Challenge/Challenge-105-Think-Like-a-CSE-Tools-are-missing/t...

Mike Spoula
Solutions Architect - Services
Alteryx
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I went for the delete and replace method. Really liked the video solution to learn a few new cute ways of fixing this common problem though.

 

Spoiler
challenge_105 - Output Astronomy Image.PNG
Highlighted
12 - Quasar
Spoiler
I went with replacing the broken macro with the one I had downloaded on the canvas. This didn't allow me to preserve the API though, so I ended up opening the file in notepad and solving it that way.

Useful trick to know!
Highlighted
12 - Quasar

 

 

Spoiler
Capture.PNG
To solve,  I clicked on the configuration on the missing tool, inserted the macro back into the workflow, and manually changed the settings back to the original configuration.

I learned a few new tricks watching the video. Thanks @MikeSp!

Highlighted
8 - Asteroid

 

Spoiler

Clicking on the dodgy macro brought up this window with all the information needed

 

XML.png

 

Highlighted
Alteryx Partner

Went for the easy route, just changed the reference

Highlighted
Inactive User
Not applicable