Register

Automatically generate Keys for Importing fact data into Data Hub module

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.

2 Comments
Stan
Community Manager
 
Status changed to: Your support is needed
hendersonmj
Contributor

Let's upvote this to put a hash function on the roadmap!

In any SQL data source it is quite simple to generate a short (<60 characters) unique key.  It would be extremely useful to be able to match up with that key from Anaplan-originated data.  If we had a function that generates a SHA or MD5 hash from a string, it would make large data sets a lot easier to deal with.  As a high sparsity data engine comes out of development, multi-million item lists are going to become more common.
 

New Solutions
tonybol
Contributor
harishroshan
Contributor
ClarenceA
Frequent Contributor