I have two data tables from two excel sheets, naming “test1” and “test2”. i want to use join data table activity to find out the “not equal” rows. I have used “!=” for that but my output is not correct.
Attached are the images. Thanks for the help in advance!
Please change the join type to Full so that all values from datatable join
Hope it helps
For more details , you can refer the documentation https://docs.uipath.com/activities/docs/join-data-tables
Mark it as solution if you got it
Nived N 
Happy Automation 
Hi, I have tried your soultion but i am still getiing all the values from both the datatables. I just want the value which are “not” common between two datatables.
Thanks!
Sorry @sameer_verma I think u require the data table to be joined in all values
Let me check
And can u share the excel file too a sample one so that I can look into
Nived N
Hi Please find attached the image set since i am unable to upload excel. First image is my “test1” datatable, second image is my “test2” datatable and third image is my desired output which i want to achieve. Thanks for help!
1 Like
I think join datatable would help to to do this
i did in another way to finds rows which are not common
gmail.zip (779.3 KB)
Hope it helps
Nived N
Mark it as solution if it helps
Happy automation
1 Like
It works! Thanks for help 
Also thank you making me learn the mechanism behind join datatable 
I was looking on to that
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.
ashokkarale
anjani_priya
Dheerendra_vishwakarma
Parvathy
Aakash_Singh_Rawat
Luis_Fernando
bjorn2390
neco
pere
Shiva_Nikhil