import a column with alphanumeric into number formatted property

Kanishq17

Hi , 

can you assist me in following , 

so i am loading a file with a column into a number formatted list property , in the csv file along with numbers some entries have text only while some entries have text along with number(as shown) , 

 

when i load this file in model , so all text lines are ignored , but somehow anaplan is taking only numbers from the lines where alphanumeric property is there 

after running the action for this list item , the property is 2411.2 , 

please guide as to how is this happening and what is workaround for this case

 

ryan_kohn

Ideally, you would resolve this in an upstream system -- either in the data source or in your ETL layer.

 

You can also build in some light transformation in Anaplan to account for a data set like this. In this case, instead of importing the value as a Number, you would import the value as Text, and convert the value into number using Anaplan formulas.

 

 

Above is an example of how you could accomplish this. Note that the VALUE() function in Anaplan will return NaN for a non-numeric value, so you'll need to have additional logic to convert those NaN values to zeros using one of the techniques in this article.