How to shorten names for a data flat file you use t import into List

neg177
Super Contributor

How to shorten names for a data flat file you use t import into List

Hi, 

 

I have a List that will get populated once a month from a flat file that is given to me from IT. The only issue is that some of the naming in the flat file is too long to bring in as a List. And if the name is too long then Anaplan will not bring in that name into the list. I want to know what is the best way to fix this issue? 

 

Thank you 

4 REPLIES 4
rob_marshall
Moderator

@neg177 

 

Change the list to be a numbered list and use Text format for the Display Name.

neg177
Super Contributor

Then I would need to change the LI to be a text verses a List and I wont be able to perform LOOKUP's on that LI. 

neg177
Super Contributor

I see what your saying to do, but I'm having difficulties importing into a number list now to populate the Display Name column I created in the properties portion of the List. Can you please provide me more detail on how you would do this? 

 

Thank you 

rob_marshall
Moderator

@neg177 

use the code of the member.