Group Buy or Sell with corresponding opposite transaction based on like data

[jmmart08]

Hi All

I am trying to build a workflow where I can pair column E (TRT) BUY and SELL based on the values in column B, C, D, F, and G being exactly the same.  For example, I would want to group lines 169 and 133 as they have equal values in all of these conditional columns AND are opposites in column E (one is buy, one is sell).  Anything that does not have an opposite transaction (again there should be 1 buy paired/grouped with 1 sell if the criteria columns match) I would just want to kind of separate from the paired groupings.  I am not really sure how to start to try to get to this point.  If anyone can give me any assistance I would really appreciate it.  Thank you so much!

TD	VD	ACCT	SEC	TRT	CP	AMT	MinOfCASH	SumOfPROCEEDS	Price
03-Feb-21	16-Feb-21	505	01F022436	BUY	WF	600,000.00	630,906.25	0	105.05
04-Mar-21	16-Feb-21	505	01F022436	SELL	WF	600,000.00	628,398.44	627773.44	104.63

[Luke_C]

@jmmart08 glad to hear, you can check out the reporting tools - I'm not as personally familiar with these but the attached breaks out the accounts. I'd suggest playing around with these and seeing, but in my experience alteryx isn't the best at outputting super formatted excel reports (it can output to a pre-formatted sheet, but that might be tricky for this also)