Need to break down Module into Multiple column Flat List

Options
BrandonEmbrey
BrandonEmbrey Member, ALL USERS, GroupMember, Community Member Posts: 2 New Contributor
in Planning & Modeling

I need some help breaking down data that has been inserted into Anaplan via the excel add in, so that each component in the existing module can be listed as individual line items as in a data list.  The attached photo lays out the dimensions I need, but I'd like to see it in a form that has the Cost center, Ledger code, date of the forecast item, and the amount each on an individual line, much like you would see in an excel sheet.

 

I just want to have it essentially flattened so that I can use the 'raw' final state to be used as an export for other modules.

 

Thanks in advance!

Tagged:

Comments

  • Tom_H
    Tom_H Member, ALL USERS, GroupMember, Community Member Posts: 5 Occasional Contributor

    Hello @prabhu 

     

    I am looking to implement something similar and found your helpful solution. Could you point me in the right direction regarding how to extract the list items from the numbered list name? E.g. how to look up numbered list code Sales~10504004-Travel Fare~711005-Jan 20 and convert it back into list item Sales~10504004 ?

     

    Many thanks

    Tom

Categories