Names in column to a business area - IF formula?

Question

Hi

I have a data set which includes the following column of names. Their names are associated with a particular business area and I need a new column created based on their name and business area. Desired outcome would look like:

NameBusiness Area (new column created)Mary RaphinhaExperience DesignPeter ForshawExperience DesignDesmond MeslierExperience DesignCat JamesBusiness DesignKirk RodrigoBusiness DesignRobert AylingBusiness Design

Assuming an IF formula of sorts will do it, but not quite advanced in my syntax to create one! Help appreciated.

Thanks,

KA

ArtApa · Answer

Hi @arundaka03 - I'd recommend:

a) Switch function: https://help.alteryx.com/20221/designer/conditional-functions, or

b) Text Input and Find Replace tool: https://help.alteryx.com/20221/designer/find-replace-tool

binu_acs · Answer

@arundaka03 There are multiple ways to do this. If you can provide some sample input file and expected output file we can show you the options.

FrederikE · Answer

If there is no pattern behind the Business Area and Name relation, i would recommend that you build a lookup table.

Just use a "Text Input" Tool, type the two columns in there and the connect it to the datastream via. the "Find Replace" Tool. There you can replace select the two name columns and choose to append the Business Area Field.

See the attached WF.

LookupFindReplaceExample.yxmd