topic Re: DISPLAY NOT MATCHED DATA in QlikView

DISPLAY NOT MATCHED DATA

kakani87 — Sat, 19 May 2018 08:26:24 GMT

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.

Re: DISPLAY NOT MATCHED DATA

kakani87 — Sat, 19 May 2018 08:32:35 GMT

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

Re: DISPLAY NOT MATCHED DATA

isingh30 — Sat, 19 May 2018 10:04:50 GMT

Can you share your data or sample application?

Thanks.

Re: DISPLAY NOT MATCHED DATA

kakani87 — Sat, 19 May 2018 12:13:20 GMT

HI Ishtdeep ...

PFA.

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 06:53:26 GMT

Can any one help me with this

stalwar1‌

tresesco‌

Re: DISPLAY NOT MATCHED DATA

tresB — Mon, 21 May 2018 06:57:45 GMT

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

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 07:08:19 GMT

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

Re: DISPLAY NOT MATCHED DATA

tresB — Mon, 21 May 2018 07:20:14 GMT

Try like:

Dim: CODE_EG

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

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 07:52:23 GMT

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 ...

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 07:57:47 GMT

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

Re: DISPLAY NOT MATCHED DATA

tresB — Mon, 21 May 2018 10:25:08 GMT

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?

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 10:53:33 GMT

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.

Re: DISPLAY NOT MATCHED DATA

tresB — Mon, 21 May 2018 11:00:37 GMT

I would use Excel and vlookup() may be.

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 11:02:24 GMT

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

with your go a head.

Re: DISPLAY NOT MATCHED DATA

kakani87 — Mon, 21 May 2018 11:09:05 GMT

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