community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Getting started with Designer? | Start your journey with our new Learning Path!

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

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

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]

 

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
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
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!
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!

Asteroid

 

Spoiler

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

 

XML.png

 

Alteryx Partner

Went for the easy route, just changed the reference

Inactive User
Not applicable