Workflow after merging two sheets

Questions
1

Hi!

I am working on a tool, that can remove specific rows.

lets take an example.

I have merged two sheets, and want to remove similar rows in the sheets.
On the left we have " bank transactions" and on the right we have the “bookkeeping”.

  1. Problem is they are not on the same row number, so I can’t use row number for anything.
  2. they do not have the same “text” as well, but I can make some rules about the text? I am thinking an AI could resolve that maybe?

as you can see on the picture many lines are the same. and should be removed because they are already bookkeeped, but we have one called “rente 0,85” that needs to stay in a new created sheet.
So we know we need to bookkeep it.

image
image1938×1456 225 KB

image
image1808×610 70.7 KB

Any Ideas?

3

I think this is the good timing to use compare dataset node

It can compare two input with same field and give you option to handle the different.