How to import data without manual mapping for Numbered list?

Hi,

I want to upload data into a module that has a numbered list as a dimension, as a result of this I have to manually map list elements manually to excel file rows

Any technique for automatic data mapping of numbered list elements to excel rows?

PFA Screenshots of my mappings for more clarifications:-

1. Source or Excel file to be uploaded

2. Mapping

3. Employee details is a numbered list & this is the mapping window

Accepted answers

Harsha

Hi,

If Employee numbered list doesn't have code, make sure to populate the code to identify an employee uniquely.

And when you are trying to load data into module which uses numbered list as dimension, please map CODE to the name of list items.

Make sure code is available in source file as per the numbered list.

Attached is SC for example.

Thanks,

Harsha

You you will have to use Code for Employee List and map it based on the code as @Harsha Suggested. If you want no failures and up to date data then first employee list needs to be updated and then the module. Long story short there should be two imports

import into employee list based on employee code

import into module (mapping on employee codes )

Thanks,

Misbah

All comments

Harsha

Hi,

If Employee numbered list doesn't have code, make sure to populate the code to identify an employee uniquely.

And when you are trying to load data into module which uses numbered list as dimension, please map CODE to the name of list items.

Make sure code is available in source file as per the numbered list.

Attached is SC for example.

Thanks,

Harsha

import into employee list based on employee code

import into module (mapping on employee codes )

Thanks,

Misbah

Quick Links

Can you help?

Unanswered questions

AnaplanXL Difficulties
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
Using Anaplan for Managing Custom Product Configurations (Example: Designer Dolls)
We’ve recently started using Anaplan to model and manage our supply chain and production planning for a niche ecommerce business that sells custom-designed dolls — each made-to-order with specific features, materials, and delivery lead times. A few interesting challenges we faced: SKU Explosion: Each doll can be customized…
Using time for something not time related - special characters :)$
We had a recent challenge with the need to "clean" invoice data descriptions from special characters. This was done previously in SQL with the a long convoluted formula "REPLACE(REPLACE(REPLACE('Ana&plan', '&', '') that would have to edited by a developer in case any new special characters came through. Using the replace…