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.
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.