Automatically generate Keys for Importing fact data into Data Hub module
Importing fact data into "flat modules" in a Data Hub is challenging when your data source is unable to provide a single unique Key to act as a List Item. That work ends up taking place between the extracted data and the import into Anaplan and oftentimes involves concatenating Key columns into a single column, sometimes manually (e.g. Excel). And there will be times when the length of the concatenated Keys can exceed the maximum supported for a unique Item Name or Code. It would be great if during import, Anaplan can let a model builder choose the Key fields and Anaplan can automatically generate something like an MD5 Hash on those Key fields that can be imported into the List first and then the fact data into the Module afterwards.
Get Started with Idea Exchange
See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!