Hi there! I'm facing below challenge:
I have a dataset ready for Network Analysis tool. The simplify dataset below:
from | to | Datasource |
fieldA | fieldD | datasourceA |
fieldB | fieldD | datasourceA |
fieldC | fieldD | datasourceA |
fieldA | fieldC | datasourceB |
fieldB | fieldC | datasourceB |
fieldA | fieldB | datasourceC |
My current state:
I am able to produce Network Analysis graph correctly (render it to HTML), but for all datasources together.
My desired state:
I'd like to render to HTML 3 separate outputs from this table (because I have 3 datasources in [Datasource] column), each Network Analysis graph should contains just one datasource and its relationships.
The challenge:
Amount of datasources (amount of outputs) might change - I need kind of a universal tool, where I just pass the data and amount of outputs is dynamic according to distinct count of Datasources. I need to prepare a tool that identifies how many of datasources are in the dataset and render appropriate amount of HTML files. How can I do it?
Solved! Go to Solution.
I would convert this then into a batch macro that does the network analysis tool multiple times, once for each data source you want to feed into it! It will also then be dynamic for future data sets that may have a different number of data sources - it will run as many times as you insert records into the Control Parameter.
Here's a good article to start: Getting Started with Batch Macros
Looks like this may also be useful: Solved: Dynamic Filter in Batch Macro - Alteryx Community
Thanks, this is it! My main confusion was not understanding batch macro correctly - I though I need an output step at the end, but in fact I can create output (HTML files) inside the macro and use it as a latest step in my entire workflow. Thank you!