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:
Name | Business Area (new column created) |
Mary Raphinha | Experience Design |
Peter Forshaw | Experience Design |
Desmond Meslier | Experience Design |
Cat James | Business Design |
Kirk Rodrigo | Business Design |
Robert Ayling | Business Design |
Assuming an IF formula of sorts will do it, but not quite advanced in my syntax to create one! Help appreciated.
Thanks,
KA
Hi @arundaka03,
you can do it using a if formula which would look like something like this
IF [Name] = ‘A’ then ‘business’
ELSEIF [Name] = ‘B’ then ‘Experience’
…
ELSE ‘other’
ENDIF
You could also use the [name] in (‘à’, ‘b’) instead of using = and having it multiple times.
but this is not viable if you have more than 8 names or if the names changes often. Maybe you could get a data source containing names and business area which would make it easier and more automated !
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.
@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.
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