Data Transformation,Adding formula based columns in Alteryx

[SurbhiMittal]

Hi Team,

Please refer to the attached excel file.

Following are the objectives of the current problem.

Column A:Classification should be formula based.If the account i.e."Column C" contains the term "Service",then it should provide the output in "Classification" column A as "Service".And if the" Service" word in not there in the Account column,it should be considered as "Software".

Please go through the formulas in Columns K,L,M,N,O.I want to replicate these formulas in Alteryx so that I can get the same results.

[Raj · Accepted solution]

use this formula for Column A : if Contains([Account],"Services") then "Services" else "software" endif