Unable to import data for numbered list

Hi,

In my model, I have an employee list which has been created as a numbered list with combination of properties (Emp ID & Cost Centre) to identify uniq. Now i have create Employee Cost module to which i need to upload the actuals number. In my source file i have Emp ID & Cost center codes. Can someone suggest me which column i need to select to import data to Employee cost module.

Thanks,

Sangeetha

Accepted answers

PaulRitner

I agree with Sheethal: If there are going to be bulk load processes affecting the numbered list, its easiest if a CODE can be set (in this case, a concantenation of Emp ID & Cost Center).

To accomplish this in a more automated fashion, you could add a module based on your Employee List that has two TEXT line items:

Numbered List Item (formula like: Name(Item(NumberedListName))... We use this so its handy when we bulk load, may not be necessary.
New Code (formula like: Code(Parent(Item(NumberedListName))) & "-" & Employee Setup.EmployeeID (The employee's ID should already be indicated in a module somewhere... so grab it from whereever it is)

Hide the parent items in the above and save as a view. Load the view into the list by Numbered List Item & set the code. Tie this into a button and make it part of your Actuals Load process.

Cheers!

All comments

Sheethal

Hi,

Add combination of Emp ID & Cost Centre (with a separator) as Code for the Employee List (eg: 1245-78643). Later you can import your Actual using this combination code which can be recreated in excel file.

To load the code in Anaplan, easiest way would be to export the Anaplan Employee list to excel with Anaplan # code, add new column for code using Concatenate formula in excel. Then, import the code created in excel file into Anaplan using # code.

PaulRitner

I agree with Sheethal: If there are going to be bulk load processes affecting the numbered list, its easiest if a CODE can be set (in this case, a concantenation of Emp ID & Cost Center).

To accomplish this in a more automated fashion, you could add a module based on your Employee List that has two TEXT line items:

Numbered List Item (formula like: Name(Item(NumberedListName))... We use this so its handy when we bulk load, may not be necessary.
New Code (formula like: Code(Parent(Item(NumberedListName))) & "-" & Employee Setup.EmployeeID (The employee's ID should already be indicated in a module somewhere... so grab it from whereever it is)

Hide the parent items in the above and save as a view. Load the view into the list by Numbered List Item & set the code. Tie this into a button and make it part of your Actuals Load process.

Cheers!

gajends

Thank you

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…