Check value in dttable1 equals value in dttable2 move to new excel sheet

Help Forum
1

Hi devs please assist, I have two tables where the value in table1 matches in table2, please how do I compare and get those values and move to a new sheet in excel. Regards!!

2

@RPA-botDev
thanks for your PM

In general, there are following approaches available

  • Lookup DataTable
  • Join DataTable
  • LINQ

With a clear defined case description along with sample data and expected output description we can work out an individual solution suggestion

1 Like
3

Alright, your solution will be appreciated, regards

4

test.xlsx (8.6 KB)
test1.xlsx (8.6 KB)
So, where sum has the same value and the total sum of the matching value equals 0, move the matching row to a new sheet

5

Are you there @ppr?

6

Hi @RPA-botDev ,

I believe the Inputs are provided, but we would also need an Expected Output to be sure as to what logic we need to use.

From this Statement, I did try to create an Expected Output, Please Check if the below is the Required Output for the Input Provided.
image

1 Like
7

Yes Superman, that’s expected output