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 
@sameer_verma
find some starter help here:
Find_Common_NonCommon_By1Col.xaml (12.3 KB)
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.
sharazkm32
yulax
pikorpa
Darshan_Sable
AJITH_SK
ruchirmahajan
Manoj_Batra
V_Roboto_V
manasrlenka25