Challenge #180: Thousand File Challenge

[JordyMicheal]

Really interesting. Might have to demo this one day

Spoiler

[garthn555]

So now I know to use the Interface Designer to allow different macro output formats. Had me stumped for a while - I resorted to using LNL's solution but it still didn't work although the macro looked identical. Should this option really be in the Interface Designer properties?

[Hannah_Lissaman]

My solution 🙂

[Verakso]

This turned out to be quite some challenge after all

Spoiler

I had the basics done, but it actually took me some time to get the same summation as the provided result

My Worflow & MacroThe Macro it self was also pretty simple
The MacroSo in the end, I did manage to match the result.

Still Climbing
/Verakso

[SeanAdams]

OK - so clearly I was a glutton for punishment.    I read this as a challenge to also deal with the ZIP file.

Attempt number 1: Read the files while still INSIDE the zip file

- Works well but not for all file formats

Attempt number 2: Unzip the file programmatically - and then read the output files

- a quick bit of python to create a new target folder

- Then another bit of python to unzip

- Then a reader; some parsing; some cleaning 

… and just like that - an overnight solution (but over several nights)..

@Hollingsworth  - this is a reuse of that directory creation trick that we discussed on another thread

Spoiler

[estherb47]

My solution is attached. Nothing out of the ordinary here.

[Ladarthure]

Nice challenge, my solution!

[cplewis90]

I spent way too much time trying to figure this out without manually unzipping the files. Once I unzipped them my regex was a bit off and made me lose some files. Once I fixed that I was able to get the right answer.

Spoiler

[TimothyManning]

Spoiler

Loved this challenge! I didn't know you could change the file format dynamically as each format has an ID. Then, the only problem was getting the schema consistent!

[JoshKushner]

I do notice that this is only 'solved' when we follow the file formats provided in the hint. When populating a complete file format list we get a very different result.

Spoiler

checked out this for guidance. turned out to be more of a distraction than a help though.

https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Documentation-tool-list-fileformat/idi-p/184...