Challenge #180: Thousand File Challenge

[Adam_Dooley]

My solution might be too simple, no macros, but it works and was pretty easy.  The caching feature helped a lot here.

Spoiler

[andresleonm]

Spoiler

My solution 🙂

[JORGE4900]

Hey there @Adam_Dooley 

Your solution helped me identify the error in my solution. I was using a directory tool followed by the dynamic input, but when it pulls the .sz extension--(Alteryx Spatial Zip File), it populates the same incorrect value for the num field for all records.

Spoiler

I was surprised that the tools pull different values. Does anyone know why? Wait a minute; I found out why; I changed the configuration of the dynamic input to read and change Entire File Path, and it pulled the correct values as seen below.

Spoiler

[Adam_Dooley]

Glad to hear the post was helpful @JORGE4900 !!

[Ritu_Gowlikar]

Spoiler

SPOILER

STEPS:

• Unzipped all the files manually and stored them in a folder.
• I created a text input file with all the file formats.

• Created a macro to read all the files from the  directory tool and file formats from the text input.

FILE WORKFLOW:

[pasccout]

Here are 2 potential solutions (see spoiler for details)

Spoiler

I almost add it done without extracting the files in advance from the ZIP but there are some file types that cannot be opened from a ZIP in Alteryx :(.


So I finally add to extract all data and then loop (at least my extraction macro was already done :)).

One other issue I had to learn the hard way... if you force a macro to return all data even if the outputs are different... you need to put a browse after... if not... only displays the first row (was starting to drive me nuts).

Overall, lots of fun using tools I don't use everyday!!!

[TonyA]

Had a few fits and starts with this one. It would help if I read the instructions more closely...

Spoiler

[Sophia]

I can't download files in any of weekly challenges. Any idea why? Thank you, Sophie

[T_Willins]

Like several other people I spent time trying to come up with a solution to read from the .zip file and got the same error on files that cannot be read directly from a .zip file.

Spoiler

[Reesetrain2]

Wow,

This one took me awhile, as I could figure out why my total was way off until I peeked at other solutions to see that the FID files were throwing things off.

-Cheers!

Matt

Spoiler