Hello Community,
I'm currently working with a report that includes various columns such as currency, purpose, customer type, etc. For each of these columns, I have corresponding tables that list the permissible values (e.g., a list of valid currencies).
My goal is to validate whether the input value for each record matches one of the enumerated values in the corresponding tables. I also want to generate a detailed summary about this validation process.
In my research, I've found that to check each individual column in my data against a different table (i.e., each column has its own table of permitted values), I may need to perform multiple join operations. However, to enhance performance and simplify workflow management, it seems a Batch Macro in Alteryx could be a more efficient solution.
A Batch Macro allows the same process (like a Join operation) to be run multiple times within a workflow, each time using a different input. In my case, it seems I can set up a Batch Macro to accept two inputs (my data and one of the lookup tables), execute the join operation, and then output any records that do not match. A Control Parameter could then be used within the macro to sequentially input each of my lookup tables.
While this approach could potentially save me from having to perform multiple join operations, I'm unclear on how to implement the Batch Macro. Could anyone provide guidance or tips on how to proceed with this?
I greatly appreciate your help.
Many thanks.
