Challenge #180: Thousand File Challenge

[RWvanLeeuwen]

Another great challenge and another learning moment 😄

My results:

Spoiler

Sum_num           Count Distinct Non Null_FileName
2.94538714461834           1000

My workflow:

Spoiler

My macro:

Spoiler

[DanielMS]

[Garrett]

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

[NicholasM]

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]

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]

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:

Outer workflow:

Result:

[LordNeilLord]

@kelly_gilbert 

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

[danilang]

Fun Challenge

Spoiler

Main

File Reader Macro

Macro

Dan

[Niklas]

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. 

[cadyb]

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