Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Re: Removing Duplicate Values

evinothk
7 - Meteor

How to remove the duplicate records having positive and negative values netting with Zero value

Company CodeAccountBranchInvoiceCurrencyReference Value 
XYXLPLSK534GBP1GHA3451    56.00
XYXLPLSK435GBP1GHA3451 (156.00)
ABCLDFMM234EUR2ABHX567   100.00
GHLFCFER678USD5BHAX565   150.00
EDFTIKTN756EUR5BHAX578 (555.00)
EDFTIKTN891EUR5BHAX578   555.00
BHKGMKPT678GBP4CA5X519   415.00
MGHTYTUS745USD1DT78901   234.00
GHJKVGHY456EUR1FTGHJT7 (528.00)
GHJKVGHY456EUR1FTGHJT7   528.00
PLHGGHKN788USD3FATYH72   956.00
KLTYBHJN102GBP9AFTYH64 1,000.00
HBHFBCJI900EUR1UYCHJK3    166.20
BJIYDCJK543GBP1HJU7501    755.00
LKHJMLTR876DKK1CMJ7602    845.00
PLOUBHNJ991SEK1GHK4156    678.00
PLOUBHNJ556SEK1GHK4156 (678.00)
LOMNUJED518USD1LKK4758   200.00
VFSDGHSD390EUR2MK4678    590.00
2 REPLIES 2
danilang
19 - Altair
19 - Altair

Hello evinothk

 

To accomplish what you want, you have to summarize based on Reference and then join back to the original data.  Filter out the ones where the sum is 0 and you have your results

 

Solution.png

 

Dan

evinothk
7 - Meteor

Thanks a lot, it is great

Labels