Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace

Data

Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace

Imagine you are supplied financials from multiple vendors and have the wonderful task of comparing them to each other? With two vendors, you could easily write out formulas in Excel for each financial line item comparing one vendor to the other. But what if you had over 1,000 vendors to compare? You’d probably quit on the spot or pass it off to someone else.

Alteryx to the Rescue

With Alteryx, you can dynamically build these formulas for any given number of vendors, run checks and flag exceptions in a short amount of time. The secret lies in understanding that no matter the number of vendors, you’re only ever comparing two at a time. By combining the Dynamic Replace tool to substitute vendor supplied values with expressions dynamically built with the multi-formula tool, we harness the power of Alteryx to simplify a mundane task.

Use Our Example

I’ve attached an example at the bottom of this post. You can easily expand this framework to span multiple checks and domains. In our example, we compare financials from multiple vendors. Ideally, they should match or be within threshold (e.g. within ±10% of each other – parametrized in our example for flexibility).

Our Alteryx workflow

Above: A quick overview of our workflow.

We could perform similar checks for retail (e.g. competitor sales as provided by different brokers or household feedback across different panels) or manufacturing (e.g. defects per million across suppliers or lead times across different freight carriers). Contingent on use case, we could also layer additional UI elements such as file input or validation check selection to expand usability.

More About the Author

Jubail Caballero

Analytics Consultant
Alteryx Tool Spotlight: Compare Values Across N Groups with Dynamic Replace Imagine you are supplied financials from multiple vendors and have the wonderful task of comparing them to each other? With two ...
Alteryx Batch Macros – Email Customized Reports to a List of Users Have you ever had the pleasure of emailing customized sales reports to 25 regional managers? How about 100 customers? It probably took ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK