Need a macro to push specific records through in a batches for spatial analysis

Hello - I'm having trouble figuring out how to solve a spatial analytics project. I have created a basic workflow with example data. The business problem is I want to look at business activity for specific dealers on a certain day (July 21st in my example, but would be dynamic in the final product). I want to compare the transactions for dealer Alpha to the other transactions for Alpha...and then the same for Beta's July 21st transactions to the other Beta transactions. Ultimately, I'm trying to verify a dealer's recent transactions are occurring within close proximity (currently set as 0.2 miles) of the past transactions for the dealer. The workflow I created compares the transactions for July 21st for all of the transactions (that weren't on July 21st). I'm thinking I need a Batch Macro to do it and only pass the transactions for a specific dealer at a time to run through the Find Nearest tool. I'm thinking the final output would be any transactions that didn't match within 0.2 miles of any prior transactions...then we could review those to determine if it a new location for the dealer or another reason for the new location.

Spatial WF - Macro Needed.yxzp

Batch Macro

Accepted answers

JoeL

Hi @byagelski ,

I was able to create such a macro by taking your example, and having it repeat in a batch macro with a filter for the vendor.

It runs each time on the data, filtering to the vendor you want every time it runs.

spatial workflow.png

This can be made even simpler by removing the Question input and choosing the Vendor column as the batch macro's grouped input (my example doesn't group the input).

spatial macro.png

Best,

Joe

Spatial WF - Macro used.yxzp

All comments

JoeL

Hi @byagelski ,

I was able to create such a macro by taking your example, and having it repeat in a batch macro with a filter for the vendor.

It runs each time on the data, filtering to the vendor you want every time it runs.

spatial workflow.png

This can be made even simpler by removing the Question input and choosing the Vendor column as the batch macro's grouped input (my example doesn't group the input).

spatial macro.png

Best,

Joe

Spatial WF - Macro used.yxzp

byagelski

Thanks Joe, this is really helpful. Eventually I'll be automating this to run each day looking at yesterday's transactions and comparing to the previous 180 days. How do I get around selecting the vendor field each time? Should I switch to an iterative macro that counts how many vendors had transactions yesterdays and then only sends those to the target of the Find Nearest tool?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703