I am really stuck with this just don't seem to be able to figure it out. I have a list of exchange rates that need to be imported into our system. The problem is each exchange rate combination appears further down the list but it is inverted. The system will not accept the import unless these "duplicates" are removed. I have provided below a small example using the GBP, USD and EUR currencies and highlighted each pair of correct and inverted instance. Does anyone know how I could remove each inverted instance.
This is almost a weekly challenge @JoeM and @kat and @NicoleJohnson should have been on top of this one. I used an Anagram technique (Challenge #59) to alphabetize the contents of the Market Entity Code field. Now EUR/GBP and GBP/EUR both appear as: /BEGPRU.
Now you can use your unique process to find the duplicates.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and restart. Order shall return. Please Subscribe to my youTube channel.
I think your solution would give incorrect answers because some countries share the same 3 letters in their currency codes. For example USD/SAR (Saudi Arabia Riyal) and USD/ARS (Argentina Peso) would both dedup in your process to /ADRSSU.
The three letter currency codes need to stay as blocks.
@MarqueeCrew, I've actually had this exact problem at work and did remember a weekly challenge. I thought more of Challenge #88 though, which preserves the full word, anagram style. That would be something like this:
But then there's @kgalbert's 2 tool solution which makes mine feel unnecessarily long!