DISPLAY NOT MATCHED DATA

[kakani87]

Hi Folks ....

I'm having 2  emp details tables from two different sources for same employees where few emp_codes they are not matching with each other now i want to find out all employee codes they are not matching with both tables

Here in this attachment you can see apart from employees "USHA,THOMAS,NITHIN" rest are not matching with each other Id's and some with name as well

And also few employees field value is null displayed that employee as well in the post

so i want to display the employee id's mismatch and null in one table i.e TAB1

NOTE:

This can be done using excel to validate like =CODE_LT<>CODE_EG  or some mapping but  the count is different for both tables emp_code wise to sort them.

The format  is exactly same as  three types in the original data so posted the example of all three types

stalwar1‌

tamilarasu‌

tresesco‌

any approach approach to achive this is appreciable

PFA.

[tresB]

This could perhaps be possible applying a very complex algorithm (to apply an association making 'almost match' or something so). But the question is - would that worth it?

[kakani87]

Yes I'm working on a costing dashboard of organisation where data is considered from two sources

I found the emp masters data mismatch compared to both sources as discussed in the earlier posts in this thread

When i point the issue with concern department .... they asked me to share the mismatch details

but not able to find out the solution

This will be useful  if i can list the mismatch details for getting updated by them

Regards,

SAI. 

[tresB]

I would use Excel and vlookup() may be.

[kakani87]

If there is a way to achieve this  but complex then i will share the proper data

with your go a head.

[kakani87]

Not an issue

I need this  list of mismatch 

by end of this discussion i will be  happy to close the thread with the help of you