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

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…