Multiple Amount Columns
854880Jun 13 2011 — edited Jun 14 2011I'm setting up an import format for a text file (to load data into Essbase) that has more than one column with an amount in it. e.g. column 1 is expense dollar amount, and column 5 is hours. the expense gets loaded to the account shown in column 2, and the hours in column 5 get loaded to an account called "Hours".
I have another flat file, with about 12 amount columns, each loading to a different stat account. Same situation.
(before you tell me that I should use a load rule and load to essbase, I know, but we're not doing it that way...)
So my question is, how do I set up the import format to load more than one data column, where I know specifically what the account for the second columns is? I don't mind having to do some scripting, but I might need and example to follow.
thanks.