Jump to content

Compare two tables data with same column name

Om joshi 3

Recommended Posts

Hello ,

I am trying to create report which is pointing to 2 different datassource. Where i want to compare values for those tables in both schema.

There are 26 table in both schema i have created information link for all tables.

Schema A table 1 and schema B Table 1 is having same column, my objective is to compare data(values) in table and find missing one.

What i already did - in Datacanvase i have combined rows for both table by matching column.

Where i know 'New Data' and 'Original Data' and i know number of difference in both table.

In attached img. you can see that for 'ABORT' action code there are for new -578 and for Old-589 rows so 11 rows are missing.

I wanted to know which 11 rows are missing in new data.

Or is there any other approch i can take .

Please advice

Kind Regards

Om Joshi

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...