topic Re: Comparing Values of two fields in QlikView

Comparing Values of two fields

baarathi — Sat, 18 Nov 2017 07:05:01 GMT

How to compare two fields of different names and are in different tables, Name of fields are UserName and UserNameFullList.Names in UserName field are present in UserNameFullList, I need to get the names from UserNameFullList that are not present in the UserName field and Store it in the separate field?

Re: Comparing Values of two fields

prma7799 — Sat, 18 Nov 2017 08:32:08 GMT

Not understand clearly please explain more ....

or please share sample file with expected output.

Re: Comparing Values of two fields

mdmukramali — Sat, 18 Nov 2017 10:34:29 GMT

Hi,

can you try something like thing,

=Count({<UserName=P(UserNameFullList)>}Name)

Re: Comparing Values of two fields

rubenmarin — Sat, 18 Nov 2017 10:46:26 GMT

Hi Baarathi, to store values in a new field has to be done in script, you can use Exists() to check if a value has been previouslyLoaded:

LOAD UserName

FROM...

LOAD UserNameFullList

If(Not Exists('UserName', UserNameFullList), UserNameFullList) as NewUser

FROM ...

Re: Comparing Values of two fields

baarathi — Sun, 19 Nov 2017 19:35:20 GMT

I am sorry for replying late sir. I will show a example below

Table1 Sample1

FieldName: UserName

Adam

Batty

Prince

Table2: Sample2

FieldName: UserNameFullList

Adam

Batty

Prince

Diana

Jessica

Now i want to compare fields UserName and UserNameFullList from two different tables, Compare and Get the names which are not present in UserName field and Store it as a seperate Field. In above example I need Copy of data of Diana and Jessica to be Under Seperate FieldName. I hope now you can understand it better sir. @P M

Re: Comparing Values of two fields

baarathi — Sun, 19 Nov 2017 19:37:48 GMT

Thanks a lot sir. and sorry for replying late

Re: Comparing Values of two fields

baarathi — Sun, 19 Nov 2017 19:38:51 GMT

Thanks a lot sir and sorry for replying late.