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.
Solved! Go to Solution.
You could use a Find and Replace tool with the table you have to append the additional column.
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