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.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #180: Thousand File Challenge

Asteroid

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

 

Spoiler
Capture.PNG
Meteoroid
Spoiler

My solution

clipboard_image_0.png



Asteroid

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
2019-09-10_11-26-46.jpg

 

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
2019-09-10_11-37-10.jpg
Asteroid

Glad to hear the post was helpful @JORGE4900 !!

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.

 

clipboard_image_1.png

 

 

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

 

clipboard_image_2.png

 

 

FILE WORKFLOW:

clipboard_image_0.png

 

Asteroid

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 :(.
Unsupported from Zip.png

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

 

Alteryx
Alteryx

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

Spoiler

2019-09-11_10-50-22.png

 

Atom

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

Comet

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
Workflow 180.GIF

 

Asteroid

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
Workflow.PNGMACRO.PNG