Apply Dynamic Rule Table managed in Excel

[nsarayar]

Hi

I would like users to manage their own rules in an excel file rather than hardcode it into the Alteryx workflow There are 60 odd rules and they are ever changing and being added to. Is it possible to apply such a rule table to a dataset

For example

If the conditions are true for the first 2 Input columns, then output the values to the last 2 columns

Input	Input	Output	Output
Settled_User	TradeSource	Settlement STP/Manual	Source Settled user
Null	ABC	STP	N/A
User 1	DEF	Low	[Settled_User]
User 2	XYZ	High	[Settled_User]

[patrick_mcauliffe]

You could keep the file on a network drive.  Then, wrap whatever workflow they apply to into a batch macro, having the control parameter update the tools where the rules apply.

Then just put that macro into a new workflow and have the file feed into the macro's input/control params.