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.
I'm looking at balances between companies comparing what is held in one company's books with another, and then vice versa (I had to do a self join to do this as it is all in one data source). This has resulted in duplicates (as expected due to the self join). I need to strip out these duplicates, but as you can see the criteria for identifying duplicates is in the opposite fields.
For example the Company 1 / Company 2 result is the same as the Company 2 / Company 1 result. I only need one of these - How can I strip the second pair out? I've tried several ways but can't seem to strip out the duplicates.
@gabrielvilella although they're large numbers, it can't really be left to chance that they'll always be unique. On the off chance that there are multiple sets of companies with the same difference, Alteryx will drop all but the first combination. The solution provided by @Luke_C is fully dynamic and will ensure true uniqueness.