This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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