LeAnnTDang
3 days agoNew Contributor III
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.