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?

Hey,
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 by loginerror
  4. While you highlight, add those missing row data from master sheet to the client.

Let me know if this helps.