The Inspire Cyber Monday promo has been extended to Dec. 1! This offer is discounted off the Early Bird price and includes 20% off for conference-only passes and 10% off training passes.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #180: Thousand File Challenge

RWvanLeeuwen
11 - Bolide

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
DanielMS
Alteryx
Alteryx

Capture.PNGCapture1.PNG

Garrett
11 - Bolide

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
NicholasM
Alteryx Alumni (Retired)

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. 

 

smoskowitz
12 - Quasar

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

kelly_gilbert
13 - Pulsar

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

 

LordNeilLord
15 - Aurora

@kelly_gilbert 

 

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

danilang
19 - Altair
19 - Altair

Fun Challenge

 

Spoiler
MainMain

File Reader Macro

MacroMacro

Dan

Niklas
8 - 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

cadyb
Alteryx
Alteryx

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