Missing Vlookup Rows

Hello everyone,

I have 2 datatables- lets call them tableA & mastertable. I need to check if every row in tableA is present in mastertable or not. So I used a lookup activity. Now, certain rows in tableA are not present in mastertable at all. I need those missing rows to be highlighted, i.e.- send an email of all those missing rows to a client. How can I go about with this?

A simple way to do this would be.

  1. Loop through both the data tables.
  2. Find a mandatory key column data.
  3. If data is null use “Set Range color” or Highlight rows using below reference code link
    Can Uipath highlight rows?
  4. While you highlight, add those missing row data from master sheet to the client.

Let me know if this helps.