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.

1 Comment
Community Manager
 
Status changed to: Your support is needed
Users Online
Currently online: 181 members 410 guests
Please welcome our newest community members: