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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #180: Thousand File Challenge

Alteryx Certified Partner

Another great challenge and another learning moment

 

My results:

Spoiler
Sum_num           Count Distinct Non Null_FileName
2.94538714461834           1000

My workflow:

Spoiler
180.png

 

My macro:

Spoiler
180 batchbatch.png
Alteryx
Alteryx

Capture.PNGCapture1.PNG

Alteryx Certified Partner

I think I missed why I would choose to use two Actions in my macro (one to update File Path and another to Update File Type).

 

Isn't that what the "Update Input Data Tool" action type is supposed to do for me? Seemed to work...

 

Spoiler
UpdateInputDataToolBatchMacro.PNG
Alteryx
Alteryx

Didn't fully read the challenge prompt, 

missed the hint,

rage quit,

finally wised up and read the prompt on my second attempt,

now we're here... 

 

Attached is my solution. 

 

Bolide

Not elegant, but certainly fun. I learned a little about brining in files as well. Is there a list of all these codes somewhere?

Fireball

At first, I didn't think this one would be too bad, but it took a few tries to get the correct fields returned!

 

@LordNeilLord, I had no idea that the FileGetExt function existed!

 

Spoiler
First, I unzipped the files using a RunCommand tool.

File input macro:
clipboard_image_0.png



Outer workflow:

clipboard_image_1.png


Result:
clipboard_image_2.png

 

Alteryx Certified Partner

@kelly_gilbert 

 

There's also FileGetFileName() & FileGetDir()!

Nebula

Fun Challenge

 

Spoiler
Main.pngMain

File Reader Macro

Macro.pngMacro

Dan

Asteroid
Spoiler
Keeping an eye on the XML really helped and saved me from having to use the data in the hint, although yxdb = 19 did probably help me realise what I was looking at. 

Main worflow.PNGmacro.PNG

Alteryx
Alteryx

That was a fun one! This is awesome practice for those getting started with Batch Macros!!