Challenge #387: LEGO® My Data (Part 2)

[olga_strubbe]

This 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.  

[gawa]

Download tool enlarges the ability and capability of Alteryx, I like it.

Saqueador

[benjimoser]

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).

Saqueador

 

[JamesCharnley]

Saqueador

Nice tougher challenge

[patrick_digan]

Saqueador

[ahsanaali]

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;

Saqueador

App 1 -  Selecting a Collection

Saqueador

App2 - Selecting Year released (only years relevant for Collection will show up for selection)

Batch macro to download the images

 

[DaisukeTsuchiya]

Saqueador

 

[Sebastian_Chaieb2]

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:

Saqueador

 

 

 

 

[rmassambane]

387!

[ggruccio]

A bit difficult to follow on the download image part, but thought it thru!  I like the way my report came out!

Saqueador