Removing contra entries

[ManuelRodrigues]

Hi 

I have attached some data. In essence this is just part of a bigger workflow that i am trying to streamline. I have certain transactions where i dont have a common name to group by so was wondering if i could potentially use the tile or record tool to get the pairings or group them via formulae?

I want to check if i can do the same process with less steps pls?

Thanks!

[pedrodrfaria]

Hi @ManuelRodrigues 

Is this what you are looking for?

This logic below (attached), uses groups of 4 to group by.

Pedro.

[grazitti_sapna]

Hi @ManuelRodrigues , I am not sure if this is what you are trying to achieve?

As per your dataset I have concluded this.

I hope this helps.

Thanks.

[ManuelRodrigues]

Thanks Re: Alteryx Version 2020.4 could i please ask why 4 & 5 dont net off pls (same numbers)?

[ManuelRodrigues]

@pedrodrfaria i tried the solution in my workflow this is what it give me:

[pedrodrfaria]

@ManuelRodrigues Your file example mentioned to group by 4 rows. This logic will group by 4 rows at a time.

I assumed this was the logic we needed to use. Are we not supposed to be create groups of 4 and then summarize then as you had mentioned?

Regarding not working on your end, the dataset you sent is in this order:

The order right here is important. Is your data in the same order? If not, please send over the dataset in the order that your data is in so we can work with it.

[ManuelRodrigues]

@pedrodrfaria 

Apologies I have set out the data as it comes out from my workflow currently see attached.