Hello. I have two data tables with only a column. Most of the row values are same in both data tables. But some values are only in one data table, and some values are only in other data table. I want to compare this two data tables and get mismatching row values. Here you can see an example of data tables:
Thank you your reply but full join solution is not the solution that I was looking for. I am trying to get mismatching items, not combine all items together.
the join is used for detecting the matchers / non matchers. From the result we can derive it.
The other options are also adressing the same: find matchers / non matchers
we would suggest to go through the different approaches and get the concepts
Oh, I pasted the code wrong. I used same code as you. On write line activity column name seemed like it changed, but I still got same error. I don’t know why. I will try other code you shared.