I have two data tables (A and B). Bought of them have several hundreds of rows of data. I need to verify that all entries from column 1 in dt A are as well available in column 1 of dt B.
Using Join dt is not helping me, as it is not iterating through all of the table´s B data rows.
Table A and Table B
Iner joing gives me following:
Data is missing (e.g) there should be match A1 A 1y.
How could I solve the issue?