adding conditions in new column

[ll1100000]

Column [item type] is my raw data, and I used formula function to add an new blank column called [item desc]

However, I want the item desc align up with item type according as below

Item type in (1,7,33) = Domestic

item type in (13,25) = DSD

item type in (15,40) = Import

Item Type	Item Desc
1	Domestic
7	Domestic
33	Domestic
25	DSD
13	DSD
40	import
15	import

Currently, I am using filter function to separate the data into three groups and then re-union them together...

Is there a better way to do this?

Thank you.

[JoshKushner · Accepted solution]

You can use a formula:
IIF([Item Type]=1 OR [Item Type]=7 OR [Item Type]=33, "Domestic", IIF([Item Type]=13 OR [Item Type]=25, "DSD", IIF([Item Type]=15 OR [Item Type]=40, "Import")))

[jdunkerley79]

You could use a Find and Replace tool with the table you have to append the additional column.

[jrgo]

@ll1100000,

you've already done most of the work. 🙂

[item desc] =
IF [Item type] IN(1,7,33) THEN 'Domestic'
ELSEIF [Item type] IN(13,25) THEN 'DSD'
ELSEIF [Item type] IN(15,40) THEN 'Import'
ELSE 'NO DESCRIPTION'
ENDIF

Drop this into your the field you created in the Formula tool.

Best,

Jimmy