Forum Discussion

LeAnnTDang's avatar
LeAnnTDang
New Contributor III
3 days ago

Matrix Data Load

We are looking to load data from a year-to-date (YTD) consolidated statement of subsidiaries. The statement is in matrix form, with accounts (both balance sheet and profit & loss) in rows and companies in columns. Each company has two sets of columns: one for financial results and one for eliminations.

How can we set up the data source to read multiple companies' statements from one file?

We would like to load eliminations to a separate origin (Elimination). How can we change the destination for the Elimination columns? 

Also, how do we set up bypass row so that the load ignores headers and total rows? I noticed those rows can be identified by the Account column, where if the account is blank, then bypass. 

No RepliesBe the first to reply