Is there a way to convert a lookup that returns a string (lookup_code hidden key) to a number (lookup_enum hidden key)? We have a few attributes that use different lookups to calculate a score which right now is in a process. I'd like to convert it to a calculated attribute but becuase one of the lookups was created using lookup_code it is not available for use in a calculated attribute. The actual values for the lookup are numbers just like in the other ones but I can't figure out a way to update what they are seen as. I tried xogging the lookup out and changing
<staticLookup autoSuggestEnabled="true" autoSuggestMaxSuggestions="10" code="ORH_ALIGNCHOICE3" hiddenAttributeName="lookup_code" sortStyle="manual" source="niku.com" status="active" update="true">
to
<staticLookup autoSuggestEnabled="true" autoSuggestMaxSuggestions="10" code="ORH_ALIGNCHOICE3" hiddenAttributeName="lookup_enum" sortStyle="manual" source="niku.com" status="active" update="true">
and the values from
<lookupValue code="1" sortOrder="0" status="active">
to
<lookupValue code="1" enum="1" sortOrder="0" status="active">
The XOG is successful with no errors, but nothing gets changed.