Good afternoon guys, how are you?
I urgently need your help. I have a base where I have the dedicated route example SOC-SP2 - HUB-STS and I have the reverse route HUB-STS - SOC-SP2. I need to identify the reverse route and delete it from my base. Does anyone know how I can make this comparison, looking only at the source and destination columns?
I thought of something that performed a count seeing if the HUB-STS appears in the second time but in column 1, excludes.
Hi @Gabriel2020
You could join the table to itself and use the “Column1 & Column2” in left side AND “Column2 & Column1” in right side as joining pairs. By doing this, you should get the rows where the Column1 & Column2 values are the same but inverted in order. From the resulting joined table you could then decide which rows keep or remove.
Sorry I cannot provide with a workflow because I’m answering from my mobile phone but this should do the trick.
Hope it helps.
Best
Ael
Good night Aworker but it didn’t work, I was doing that too. Hence my doubt. I’ll tell you what happens. But basically when I remove the duplicates it ends up giving the same error.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.