Import a csv file to a module where "Months" are line items
I am struggling with import data where one of its columns represents time "YYYYMM" to a module where Time dimension is "Year" and "Month"s are a line items. Would you take a look at the attached to see what I would like to achieve ? Such an import ever possible ?
I know this is an old string, but I am hoping you can share how you have accomplished the opposite of the original question: transform a source .csv with months as columns to a target module with month as a field?
Thank you for the response. Great question. Current proposed structure of the target module only includes a record "ID" and does not include the real time dimension. Time will be created as a property via formula. Attached screen capture provides more detail.
Please note that the structure of the target module can be changed if there is a better way. But the end goal is to transform the "crosstab" source into a more "database" style module.
1. D01: to store data from Source file and the months will need to be defined as numeric line-items.
2. D02: Creating a line-item subset, COLLECT() data from Source module. This way you will pivot data in rows for the months. (maybe you will need a mapping module for the line-item subset, if you need a different way to store data in final module like using the Anaplan Time list).
3. D03: Final module to import data from the D02 module. Here you can choose for the Time: property or use the Anaplan Time list. Usually, I would choose for separate dimension for Time.