Hi All,
i have used used contain function to match two fields, it is giving "match" for many cases. how to fix it, for below criteria im getting true for both rows.
Field1. Field2. Match
AIM. Claims and Investigations. False
AIM. AIM Director. True
Thanks in Advance,
Niranjan
Solved! Go to Solution.
recordid
text to columns split field2 by space
formula tool - new boolean field called match
[field1]=[field2]
summarize tool
group by recordid
max value of match.
join recordid->recordid.
@apathetichell Thank you for quick response,
if i use Text to columns for Field2, i will get 10 to 15 columns, how can i compare Field1 data with 10 splited Field2 columns data in one time.
Actually i have to compare Many to Many fields data. how can i achieve data comparison. kindly help me.
forgot to mention - split to rows. its a configuration in your text to column tool.
@apathetichell Can you give me any sample workflow comparing fields i have used lookup function its not working. for below secnario only it is matching when separate filed. i have to find if matching field1 data to Field2 i have to update True.
Field1 Field. Match
24 T24. True
24. word24 True
kindly suggest me
Is the logic structure that your match is case sensitive? If so you can go back to contains (which should not be case sensitive- and should differentiate between AIM and claims for example) - if your match is not case senstiive - I'd recommend going back to the drawing board because I do not see a logic structure you can use to match 24 in T24 but not match AIM in claims.