Tableau Induced Alteryx Workflow - Percent Similarity

[muddobber26]

Hello - I am trying to figure out a way that using a Tableau dashboard, I could induce an alteryx workflow to compare the components of a sellable unit to the components of every other sellable unit in the same file to output a "% similarity" column in Tableau. For example: Below I have three distinct sellable units in an excel file where every row is a unique OR shared component. In the same row is the sellable unit that the component is mapped to. In my tableau dashboard, if I inputted or filtered for 123456-00, I would want to know "what percent of the components tied to 123456-00 are ALSO tied to 123457-00 and 123458-00. Is this possible?

Sellable Unit	Component
123456-00	456789-10
123456-00	456789-11
123456-00	456789-12
123456-00	456789-13
123456-00	456789-14
123457-00	456789-10
123457-00	456789-11
123457-00	456789-12
123457-00	456789-13
123457-00	456789-14
123457-00	456789-15
123457-00	456789-16
123457-00	456789-17
123457-00	456789-18
123458-00	456789-10
123458-00	987654-00

[muddobber26]

@DataNath Circling back on this one. What if I wanted to create a loop where I could have a table of values that are input and looped through the filter tool to output batches of data? Would that be a batch macro? Not very familiar with those. 

[DataNath]

So you'd want to conduct this workflow but instead of having a user selection, you'd want Alteryx to automatically run through - changing the Sellable Unit each time - and output the results as one? If so, then yes that'd be a perfect Batch Macro use case. All you'd need to do is pass a list of your Sellable Units in to the upside down question mark (control parameter).

[muddobber26]

Yes. I would want to input a list of Sellable Units and then have Alteryx run through and output all of the results in one sheet. I read this blog post (https://interworks.com/blog/mtreadwell/2015/11/20/control-parameters-and-simple-batch-macros-alteryx), but not going to lie, I still don't quite understand how to set things up as my macro knowledge is pretty limited. Any way you show me how it works?