Two inputs in a macro

damiana_spadafora

Hi everyone! I have created a data checks workflow that I would like to turn into a macro. The first step of this macro is to take two different files and join them, then check the output in the left, inner and right join and display a message in the log window according to what it has found. 

I am not entirely sure how to proceed, do I simply use two macro input tools or is there anything else I should be aware of?

Thank you,

Damiana

MarqueeCrew

aye, there's the rub!

The simple answer is for a single join key.  You would connect the macro input to a drop down interface tool and then update the value.  I've not updated a join tool this way before however.  When you have multiple keys, the answer requires more work.

Here is an example macro that allows a user to select the groupby field from a macro input.  It is a modified record ID macro that allows you to assign text/numeric values within a grouping key:

https://gallery.alteryx.com/#!app/Record-ID-for-Groups/555c9efd398a71086464c43c