Merge the two dataset and find the difference
Dataset -1
TableName RowCount
Table-1 12
Table-2 15
Table-3 18
Dataset -2
TableName RowCount
Table-1 12
Table-6 15
Table-3 10
It should only return the distinct entries , i.e. the entries which are altered or not present in one of these.
The result should look be like this:
TableName Ds1-RowCount DS-2 RowCount
Table-2 15 Null
Table-3 18 10
Table-6 Null 15