how to use contain or match function

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

Datasets

Developer

Developer Tools

Output

Best Practices

Fuzzy Match

Data Investigation

Accepted answers

apathetichell

forgot to mention - split to rows. its a configuration in your text to column tool.

All comments

apathetichell

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.

NiranjanK1

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

apathetichell

forgot to mention - split to rows. its a configuration in your text to column tool.

NiranjanK1

@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

apathetichell

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.

anjelabugarin

Just adding to @apathetichell's point if match should be case sensitive or not - you may consider using regex match instead for case sensitive use case. Kindly check workflow and output.

sample.yxmd

sample1.PNG

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703