1 Reply Latest reply on Dec 16, 2011 1:49 PM by SH_INT

    Upload multiple records in one row from source file into HFM using FDM

    904448
      I am trying to solve a problem at a client where they are trying to upload 7 records for each row of source filedata. Excel file contains 9 columns in total, wher the first two columns represent the dimensions for the following 7 columns. the 7 columns contain the amounts to be posted to the row dimension...any urgent help will be appreciated.

      Senelstun
        • 1. Re: Upload multiple records in one row from source file into HFM using FDM
          SH_INT
          This can be done in an import script. Take one of the amount columns to load using the default import format method and then for the other 6 amount values use a script to push them into the worktable as additional rows. If they are not bothered about having all the lines individually in the import dataset then your import script would simply add the 7 amount values together and post agianst the imported row with no need to manually insert records to the worktable.
          1 person found this helpful