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.
Could anyone please tell me how I could find a combination of row values in a column? This is what the source file looks like
I would like to find how many time a set of account combination occur, regardless of their values.
Thanks a lot for the help, I hope that makes sense. Happy to clarify any points.
I think I understand what you're trying to do here. In excel, what is the grouping field for the Subtotals? (Look under Data->Subtotal->At each change in:) It is not shown in the image you posted.
If you have this grouping field in your input to Alteryx, it would make finding the account combinations much easier.
If you get a chance, please post some anonymized data and clarify what you want the output to look like.