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.
Alteryx Gallery is experiencing a problem in which system emails are not being sent out. As a result, if you are attempting to sign up for a new account, you may be unable to verify your email address. We are working to solve this as soon as possible and will remove this notice once resolved.
Imagine that I have teams and I need to assign places for them to go. Each team can go to a max of 3 locations and two teams can't be assigned to the same location.
So I want to find the combinations that are unique in its three locations
The rows are combinations of locations that already match the criteria required.
The value is just because I want to select the ones with the highest value ,so I sorted the combinations of three by value
In this example, the result would be:
See that combinations may have only two locations (i,i,j)
So basically, for every row I need to look at the rows above and see if any of the locations in the current row is in any of the locations in the rows above. If it is, delete the row, if not keep it, then go to the next row. I am trying to use batch macro but I am new to it.
Yes, you can do that with a macro. I've dropped a very quick working example in the attachment below (using your example file). The workflow appends the field [KeepRow] (with a 1 or 0) so you can then see which rows you're removing at the end. The macro essentially searches for repeat value in any of the rows above (by transposing). I've done it as an iterative macro as we don't then want to compare to any rows above that we have since deleted (i.e. since changed to 0).
Let me know if there's any issues or it's not what you were after. Feel free to tidy the macro up; I'm sure there are a couple of ways to do this!