Able to use the row id number as unique identifier when import a file
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...
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!