Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Weekly Challenges
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
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.
Spoiler
Workflow:
Macro:
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.
Here is my solution, used a batch macro, then summarized all results, great challenge!
Spoiler
Spoiler
