Table Content Exception Reporting


#1

Hi,

I have two tables from different sources (Data Warehouse and Operation Systems).
Ideally both should match. But if for some reason, they don’t, I want only exceptions to be highlighted.

Is it possible in RPA Express Sunbird 1.1.3?

If yes, how?


#2

Hi @Sandeep_Varma,

It is doable, you can check this topic to understand the approach:

So you can do one of the following approaches:

  • switch between 2 Excel sheets and compare them line bu line
  • OR read each table in a variable and compare them in a For Each loop

#3

Hello @azinchuk,

Thanks for the work around. Appreciate your efforts to include indexing. Waiting eagerly for this and have voted as well.