Forum Discussion
Solved
Remove rows based on an arbitrary rule
Hi! so I have a table of currencies and their corresponding countries, and some countries have more than one currency (so they have more than one row in this table). Moreover, I need to merge this ta...
Because the rule is completely arbitrary, and I know for a fact that the order of the rows, as well as the number of them, won't ever change, I solved this by simply creating an index column and filtering by it, manually removing the indexes I'm not interested in. In the end it was a very easy solution.. Thanks anyway guys!
You could add a column to the curreny table that acts as a flag for which currency to keep, filter on this flag and then merge. Well, I think that would work. Also if it doesn't matter which one the system keeps (could hardly imagine this though) then of course you could simply remove the duplicates based on the country field.