Merge rows by compare them and flaging differences

Hi @Mobarak_Said and welcome to the Community,

comparing rows is described in this topic: For each record

To identify new and deleted rows you can use the “Lookup action” in both old and new tables. When a new key is not found in the old data it’s a new record. When an old key not found in the new data it’s a deleted record.

Alternatively, use actions “Keep matching” or “Keep mismatching”.