Checking Between Two Data Sets

[tomtingley]

Hi,

I'm trying to connect two data sets to flag any differences.

To explain, I have three buildings in the 'Join' file and four buildings showing figures in the 'Data Report' file.

Both files have Building A, B and C in them, but Building D only appears in the Data Report.

I want to flag Building D (in this case) in the Output file because it does not appear in the 'Join' tab.

Hope this makes sense. I've attached the files for help.

[ShankerV]

Hi @tomtingley 

One way of doing this.

Many thanks

Shanker V

[ShankerV]

Hi @tomtingley 

Step 1: Input both datasets.

Step 2:

Step 3: Deselect unwanted columns

Step 4:

Step 5:

Step 6:

Many thanks

Shanker V