This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I need some help with creating a workflow which I have been trying for so long and I can't find the right way, I am still getting to know the tools. Perhaps some of you have some smart ideas.
I need to create a workflow which creates a table out of a series of variables as you can see in the picture (we can omit the values of the matrix input for the workflow only the variables are relevant):
The workflow has to create a table which puts two number "1" in each column for each combination of the variables, for instance in the first column (Rep1) there is a 1 in "ab" and another 1 in "ba". And it has to do it successively with all the possible combination of the variables, only when the variables are combined with another one.
The difficulty comes due to the following conditions for the workflow:
- The variables are coming from a matrix and each letter represents a product as you can see in the picture. As the products of the matrix will be changing it can't use any tool/formula that selects a specific name/field because otherwise it can't be automated.
- The matrix will change also in size, so it needs to adapt to a N*N matrix.
I think a solution might be telling the workflow that "ab" and "ba" are the same, but I could not manage to do that. I am open to any kind of suggestions and ideas.