Jump to content

How to remove rows with same column values from two data tables

joy lee 2

Recommended Posts

I have two Excel sheets with rows with the same column value.

I want to remove the row with the same ID,INDEX,CODE as the left table like the attached file.

Is there a way to remove it using a join method I'd like to process about 100,000 data sets.

please let me know how to do this..

Link to comment
Share on other sites

I am not sure this is the best way, but something along those lines should work:

let's call the left table 'table1' and the right table 'table2'

Click on + and add a data table from table1, call it e.g. table_merge

join table_merge to and table2 on INDEX and CODE with join type Right single match join

still in the canvas, add transformation Filter on [iD] is null

remove [DATE] and [iD]

you're left with ID(2) which you can then rename

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...