Loading Data with many-to-one relationship
I believe this is straightforward, however I haven't been able to word my searches to find what I'm looking for - so either it doesn't exist or I cannot find it. Going to throw this out there:
Our general ledger Actuals have individual (unique) accounts which have a many-to-one relationship with account groupings (I.e. individual cash gl accounts all map to one parent "cash"). My model only needs parent level grouping values to build forecast scenarios. I've built two flat lists: L1 for the individual accounts and the other, L2 for the parents/grouping with the parent relationship identified. Is there not a way to use the L2 Groupings list in the Actuals Module where I can load the individual GL account Actuals that auto map to the L2 groupings? Is there a better approach to solving sparsity issues by avoiding GL account details? We're always adding accounts, so I don't want something that is a burden to update.
Additional goal: I also have a separate "product" list I am applying in the Module, but I only need it to apply to maybe 5% of the GL accounts (so a large waste of space), but if I can make this mapping GL accounts to parent groupings I'll save space since about 50% of the groupings (L2) have the product code.