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.

[kakani87]

My Intention behind this is to list all the employees where code <> code and get them corrected to match with

As I'm using this masters for the purpose of costing dashboard  in order to associate data properly

[isingh30]

Can you share your data or sample application?

Thanks.

[kakani87]

HI Ishtdeep ...

PFA.

[kakani87]

Can any one help me with this

stalwar1‌

tresesco‌

[tresesco]

Do you want to show the names if codes don't match? In the UI or script?

[kakani87]

Actually they need to be shown in UI to list them and get corrected from HR department

[tresesco]

Try like:

Dim: CODE_EG

Exp: If(not Min(CODE_EG=CODE_LT),NAME_EG)

[kakani87]

NAME	CODE_LT	CODE_EG	NAME
SAIKISHORE	-	C000838	SAIKISHORE
AFZAL BAIG	AF	AFZAL	AFZAL BAIG (90100199)
AJITH C	AJI	000872	AJITH C
K N YOGESH RAO	YOGES	YOGESH	YOGESH K (89100900)

My intention is to show CODE_LT <> CODE_EG

where the data looks like above format

Am i able to let you know what my requirement is ...

[kakani87]

As per my understanding if both the rows are equal then i do pull the data into excel and check like

=C1<>C2 and check them

But here in this case count of rows they are not equal like employees