Formula Replacing Multiple "ID code"

[jcsoh]

Hi all,

I I would like to replace some of ID in the "ID code" column. Please advise how I could do it in Alteryx? I list below examples of what I want.

Before:

Company Name	ID code	Total
Company A	1	100
Company B	2	200
Company B	3	300
Company D	4	400
Company E	5	500
Company F	6	600
Company G	7	700
Company H	8	800
Company I	9	900

After:

Company Name	ID	Total
Company A	1	100
Company B	BB	200
Company B	BB	300
Company D	DE	400
Company E	DE	500
Company F	6	600
Company G	OTH	700
Company H	OTH	800
Company I	OTH	900

Cheers,

J

[patrick_mcauliffe]

What have you tried so far?

This looks like it just requires a formula.

Example: 

if 

[Company Name] ='Company B'

then 

'BB'

elseif

.....

and so on.

[jcsoh]

Hi @patrick_mcauliffe do you mind doing up some mockups based on my examples? I tried your suggestion but didn't seem to work.

[DavidP · Accepted solution]

As @patrick_mcauliffe said, you can use an IF ELSEIF statement, either on Company Name or ID

[grazitti_sapna]

Hi @jcsoh , you can either use this formula on id code or company to get the desired output.