Importing Combination of data in numbered line item

Venki9902

Hi Team,

I was trying to Import the wrong data(combination of text and numbers) to my numbered format line item "Data".
However, Anaplan did not through any error for the same(mentioned in the below screenshots).

Just curious to know how Anaplan treats this kind of data and can someone please explain how this will work in behind?

Regards,
Venkatesh

Relanto

Hi @Venki9902

As the line item in which you are importing is Numbered formated, so it will ignore the Text and only import the Number, where as if you change the line item format to the Text it will consider the value as text and import the full value ie: combination of alphanumeric.

Please refer to the ss below.

Hope this helps you..!

Girish

Hi @Venki9902 ,

Please go through the below link for a more detailed understanding.

https://community.anaplan.com/discussion/135278/import-a-column-with-alphanumeric-into-number-formatted-property

Venki9902

Hi @Girish and @Relanto ,

Thank you for your details.

But however, what I am trying to convey is instead of creating the extra line items to check if the data has a perfect number(not an alphanumeric character) Anaplan should through an error or something :).

Regards,
Venkatesh