A task we often undertake is cleaning data with Alteryx. Part of this includes creating what we would call mapping tables where we will generate a list of unique values in a data source, provide each value with an ID and write that "mapping table" to a file where we can make manual edits. We will then join it back into the original data source to update the values. I was hoping to make a macro that facilitated this mapping table creation process as well as creating IDs in the original data.
What I would like to do is read a workflow into a macro, select the fields that will be used to create unique values, provide those fields with a mapping id and then join only the mapping id back into the original data. I have attached a workflow that attempts to do this. However, I am unable to figure out how to parameterize the unique tool to select the appropriate fields and the join to select the appropriate join elements (and deselect the right join fields).
If anyone has any insight as to how this could be accomplished it would be appreciated!
