Comparing Values of two fields

[baarathi]

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?  

[prma7799]

Not understand clearly please explain more ....

or please share sample file with expected output.

[mdmukramali]

Hi,

can you try something like thing,

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

[rubenmarin · Accepted solution]

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

[baarathi]

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

[baarathi]

Thanks a lot sir. and sorry for replying late

[baarathi]

Thanks a lot sir and sorry for replying late.