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 |
Solved! Go to Solution.
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 : )
Hi
Thanks for your response however The letter keeps changing and different every time.
Could you show me while creating workflow.
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 : )