Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAThis was a tough one. I leveraged the solution provided by @AkimasaKajitani . Thank you, Akimasa, for teaching the way to solve it. I usually get confused with the prep data for List Box and Drop Down tools; and this was a great example of how the data needs to be wrangled in this case.
Download tool enlarges the ability and capability of Alteryx, I like it.
My Solution. I actually did it without a Batch Macro. No idea why this was mentioned in the challenge description. There also seems to be an data input quality issue (e.g. Star Wars Models from 2014 are not listed on brickset.com).
Nice tougher challenge
This challenge is great for learning/revising interface tools, chained apps, download tool and batch macros. Learned and copy the interface technique between List Box and filter tool from @AkimasaKajitani (very elegant solution)
I opted for Chained Apps to solve this challenge. Here are the screen shots;
Batch macro to download the images
As officially Solution is attached, I am posting my workflow/App when I was designing this Idea.
I was so queries how other Aces and great experts will solve it. I believe that reviewing all posted solutions I will learn a lot how it can be done with simpler/better way. Congrats @AkimasaKajitani for being the first one who posted ready solution. Amazing
Thanks you all
My Solution:
A bit difficult to follow on the download image part, but thought it thru! I like the way my report came out!