Microsoft | SDE | Hyderabad

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