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.
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.