Challenge #180: Thousand File Challenge

[paulfound]

Spoiler

[JennyMartin]

Spoiler

Nifty trick!

[AngelosPachis]

Challenge #180 solved

Workflow:

Spoiler

Batch Macro :

Spoiler

[JethroChen]

Spoiler

[mollyhatch]

Spoiler

[AkimasaKajitani]

My solution.

Spoiler

Reading Macro

I use the Alteryx version 2020.3. 

The behavior of the shape files loaded in this challenge is a little strange at this version.
Now the solution Workflow doesn't work.
When I run the Workflow, the field name of the shape file is changed every time.

When the solution file was created, I think it was all loaded with "Field1".

And I think that the shape file have blank field name.

[Paradox]

Spoiler

Workflow:

Macro:
Used a macro to open each file, transpose the data inside, and filter "fid" and SpatialObjs. Converted the data to a number outside the macro before summing.

[michael_leoni]

Please see my solution below. 

[getintodata]

Here is my solution, used a batch macro, then summarized all results, great challenge!

Spoiler

Spoiler

[TraceyD]

So much to learn about batch macros!  Grateful for the solutions....  🙂