create new raster from attribute field

Question

Dear all,
I have a global raster with an attribute table where some attribute fields are joined fields from another table. I want to create a new raster from one of the other fields in the attribute table. Does anyone know how to do it? (Lookup doesn't do the job, I have a 1-band raster file). 
For more information its the Harmonized World Soil Database (HWSD) data (raster file with attribute table)

TatianaKharitonova · Answer

Thanks for your lifehack! Ten years passed it's still no better solution

KodaiYamamoto · Answer

This helped my process of HWSD. Thank you.

Anonymous User · Answer

this helped, thanks