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 TypeItem Desc1Domestic7Domestic33Domestic25DSD13DSD40import15import 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.

adding conditions in new column

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.

Common Use Cases

Accepted answers

JoshKushner

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")))

All comments

JoshKushner

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

Quick Links

This months top contributors

hhaigh1 280

FláviaB 262

JORGE4900 235

caltang 177

DanM 167