It would be really useful if the row id number ("Line #") would be available as additional column when import a csv file or from any other external source.
When import files in Anaplan, usually the first step is to import the file into a numbered list where the file columns are transformed in numbered list properties. To be able to load the file usually the “Choose properties below to build the unique identifier for the imported items” option is used where are chosen the combination of columns that identify uniquely a row in the file.
Sometimes identifiying the "primary key" of a file is not always possible.
This way it would be possible to use the row id (row number "Line #") of the file as a property to be used to be able to choose as unique identifier.
This row id it seems that is already available in the "back-bone" of Anaplan becasue when rejection file is created there is the information of the row number in the "Line #" column.
It would be very useful if the row number from the file would be available to be chosen as an option for “Choose properties below to build the unique identifier for the imported items”
Of course there is the workaround to ask the provider of the file to create this additional column, but also, sometimes in a project this could become really difficult...
The content in this article has not been evaluated for all Anaplan implementations and may not be recommended for your specific situation.
Please consult your internal administrators prior to applying any of the ideas or steps in this article.