Compare two columns in excel tables, check if every cell exist in another table

Hello everyone, I’ve got two excel tables, I need to start with first cell of table1 and compare with every cell in table2, and loop it to the end of table1 and write all cells which does not exist in table2 in new column for example.
Sorry if its not new request, but i saw only row compare, not each cell with each cells.
Two random tables in attachments.
Thanks for help.

table2.xlsx (8.0 KB)
table1.xlsx (8.1 KB)

Hello Hello

Suggestions to solve it

  1. use stream flow
  2. Obtain in a data table the data of each excel file
  3. Scroll any of the two tables within one for each row
  4. Make a data selection with the value to search.
  5. Ask if values ​​have been found and perform the corresponding actions.
  6. finally

Hello @alexkrave

I guess the best & the efficient solution for you is Datatable Joins

here, they mention a join type called “Left Join”. In this method, the join will produce nulls for all the records that do not match to any record in table 2. That’s the set of records you are looking for :slight_smile:

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.