Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
baarathi
Creator III
Creator III

Comparing Values of two fields

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?  

1 Solution

Accepted Solutions
rubenmarin

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

View solution in original post

6 Replies
prma7799
Master III
Master III

Not understand clearly please explain more ....

or please share sample file with expected output.

mdmukramali
Specialist III
Specialist III

Hi,

can you try something like thing,

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

rubenmarin

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
Creator III
Creator III
Author

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
Creator III
Creator III
Author

Thanks a lot sir. and sorry for replying late

baarathi
Creator III
Creator III
Author

Thanks a lot sir and sorry for replying late.