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

Delivery Architect
Tableau’s New Data Model: Physical vs. Logical Data Sources With the recent release of Tableau Desktop 2020.2 came the introduction of a brand-new data model. In versions prior to 2020.2, users ...
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 ...

See more from this author →

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

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072

×

Insights are just a search away! - Join our webinar on June 21 to see ThoughtSpot in action.