Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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 ...
Not understand clearly please explain more ....
or please share sample file with expected output.
Hi,
can you try something like thing,
=Count({<UserName=P(UserNameFullList)>}Name)
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 ...
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
Thanks a lot sir. and sorry for replying late
Thanks a lot sir and sorry for replying late.