Import Transaction Data to Data Hub Module with Numbered List

alexlee

Hi,

 

I have created a numbered list module with no item yet (Refer to image 1)

 

When I import the transaction file into the module (image 2), what can I do to auto create item in numbered list (#1, #2, #3, #4)?

 

Thanks

MarkWarren

You'll want to create a code based on unique properties of the data. From your screenshot this would suggest a combination of GL_ACCOUNT and PROFIT_CENETER_CODE. You would then build a view to use to import in to the list. Once done you can create a module dimensioned by that list and Time, so you can import items matching that code and the GENERATION_DATE (the same code you used to create the list).
This would then show the total AMOUNT for each GL_ACCOUNT and PROFIT_CENETER_CODE combination by Time.
For some further reading on importing data and data hubs try this article:
Data Hubs: Purpose and Peak Performance - Anaplan Community