Data Cleaning - If Statements

Hi Guys,

Data cleaning in Alteryx using if statements and contains

In the sample excel file attached - I am only concerned with the Resource Name equal to 'Labor Vendor 0000025308,' ignore the remaining resource name. With the Original Name Column I am concerned with the 'John Resourcing ....' only when the resource name is 'Labor Vendor 0000025308,'

Basically I want to an IF statement on 2 variables with contains and replace , if it does contain a match

If Resource Name equals 'Labor Vendor 0000025308,and Original Name contains (John Resourcing) // Note I do not care about the Month after John Resourcing

Then Resource Name equals John Resourcing

Else Resource Name

End if

Thanks Tommy

Sample Data.xlsx

Accepted answers

atcodedog05

Hi @Tommy_Alterax

Here is a workflow for the task.

Was caused because there was commas at the end fixed it

IF [Resource Name]="Labor Vendor 0000025308,"
and Contains([Original Name], "John Resourcing")
THEN "John Resourcing"
ELSE [Resource Name] ENDIF

Output:

Hope this helps 🙂

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

vendor.yxmd

All comments

atcodedog05

Hi @Tommy_Alterax

You have attached the wrong excel. can you please provide the right excel.

Tommy_Alterax

Apologies - attached now

Sample Data.xlsx

atcodedog05

Hi @Tommy_Alterax

You condition is almost giving the formula

IF [Resource Name]="Labor Vendor 0000025308"
and Contains([Original Name], "John Resourcing")
THEN "John Resourcing"
ELSE [Resource Name] ENDIF

overwrite on resource name like this

Hope this helps 🙂

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703