Find True and False

[mmustkee]

Hi Team,

 I have data and wants to find True and False. I want if first three letters and last three letters are the same then we should mark as True or False.

Please find example below:

AA	Result
abs/zsd/rdf	FALSE
abs/zsd/abs	TRUE
tbs/zsd/abs	FALSE
zbs/zsd/abs	FALSE
zbs/zsd/zbs	TRUE

[atcodedog05]

Hi @mmustkee 

You can use Left() function to get first 3 and Right() function to get last 3 characters and compare them.

You can refer to the documentation page for its usage https://help.alteryx.com/20221/designer/string-functions

Hope this helps : )

[mmustkee]

Hi 

Thanks for your response however The letter keeps changing and different every time.

Could you show me while creating workflow.

[suby · Accepted solution]

See the attached Workflow hope this helps.

[atcodedog05]

Hi @mmustkee 

Left() function and Right() function are dynamic to get first 3 and last 3 characters. Hence it should be able to handle it.

Here is a workflow with explanation

Hope this helps : )