I'm pretty sure this is solved with an interface tool, but unsure as to the direct solution.
The situation:
I have a set of data that contains multiple categories, of which I want to perform a KNN search within each category. My intent was to build an iterative macro but there are two dynamic pieces of the configuration that will change with each category:
1) the data will be one-hot encoded, but the column names with each category will change. There may be some overlap between categories but not always. For each iteration I want to use every column in the KNN search.
2) the number of nearest neighbors for each category may be different, as we are searching against different templates. One category may have 1 template, others may have up to 6.
Given the large number of categories I'd rather not do each of these manually if possible.
Example workflow is attached.
You can see where each category has a different number of templates and the configurations between them contain different values. The values in the configuration column will be one-hot encoded before being fed into the KNN tool.
What I need to do is pass these values for number of templates to the KNN tool and have it update the number of neighbors to search, and then to have the check box with the KNN tool to refresh with the new column values and have all values checked.
Any ideas?