Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Authority Limits Example

tgarf12
5 - Atom

Does anyone have an example of a workflow where you have a list of people and their approval authority limits (i.e, person with level 1 limit can only approve claims under 75,000) and compare to a list of payments made (i.e a list of all claim payments) to ensure that every payment made was within the authority limit of each individual? This would be a quick way to automate a control test for a full population. 

2 REPLIES 2
gabrielvilella
14 - Magnetar

This would be easy to demonstrate with some sample data if you could share that. 

danilang
19 - Altair
19 - Altair

Hi @tgarf12 

 

Here's a simple example

danilang_0-1648301155825.png

The top input contains the limits for each person and the bottom one, the transactions.  Join the limits to the transactions on Person and use a formula to check if the transaction is over the person's limit

danilang_1-1648301271690.png

Dan

 

Labels