How to import multiple header rows into a module?

Options
kdoan
kdoan Member, ALL USERS, Community Member Posts: 5 Contributor
in Extensibility

The import file is an export file from a module that I am working on. There are several header rows that I need to import into the module. How can I do this?

 

   Jan 19Jan 19Jan 19Jan 19Feb 19Feb 19Feb 19Feb 19Mar 19Mar 19Mar 19
   ActualActualForecastForecastActualActualForecastForecastActualActualForecast
   AmountCommentAmountCommentAmountCommentAmountCommentAmountCommentAmount
N/AEphany, LLC7211 -  Content / Creative0 0 0 0 48,000 48,000
N/AExtron5110 -  Cost of Goods Sold - Hardware350 350 0 0 1,502 1,502
N/AFedEx - Autodebit7770 -  Freight Expense (non COGS)0 0 0 0 0 0
Tagged:

Comments

  • caleb.maxson
    caleb.maxson Member, ALL USERS, Partner Posts: 2 New Contributor

    If this is a module-to-module import and you need to map all the dimensions from Module A to Module B, you can create a saved view in Module A with the dimensions in the page instead of the columns. If you import that saved view, the dimensions will all be on the rows and mappable to the new module.

     

    Importing from saved views is often best for module-to-module imports because they can be optimized with filters, etc. and are less prone to breaking the import if updates are made to the module.

     

     

Categories