Formula Help

[Anthony_grey85]

Good Day Alteryx Community!

I'm seeking some guidance on how I might compare item descriptions from say three different data excel sets to identify if the descriptions match. I've been stuck for some time searching for help but can't seem to find exactly what I'm looking for. I'm able to create the joins fine, but can't seem to get the right IF Statements. Hoping you all can help!

Example:

Item 123456 

Description 1: Knee Femoral Component

Description 2: Knee Femoral Component

Description 3: Knee Femoral Component 2.3mm

Outcome:

If Description 1 = Description 2 = Description 3 Then use Description 1 Else state "Needs Resolution"

Example 123456 Outcome: Needs Resolution

Thanks all!

Anthony

[atcodedog05]

Hi @Anthony_grey85 

Formula would be

If [Description 1] = [Description 2] and [Description 2] = [Description 3] Then [Description 1] Else "Needs Resolution" Endif

[atcodedog05]

Hi @Anthony_grey85 

Here is a workflow for the task. Using above formula

Output:

Workflow:

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[Anthony_grey85]

Thank you! This was extremely helpful!

[atcodedog05 · Accepted solution]

Hi @Anthony_grey85 

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

[atcodedog05]

Happy to help 🙂 @Anthony_grey85 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂