Hello all, I have two dat tables that im trying to get merge into a single table but does not have any matching cells. ie. if items from table one occur in table two i dont want them to show up in the merged table at all. I can think of plenty of ways to do this via python but was wondering if anyone knew a good way to do this with DAT’s. any ideas?
The Sort DAT has a uniqueness parameter. You can make rows unique or a cell in a specified column unique. The only inconvenient thing is uniqueness by a combination of columns. To do that you’d have to make an artificial column for the combo, then sort with uniqueness and then remove it again.
Thanks for the idea!!