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
