Level 1 Model Building Exam Activity 4 - Roles Import Error

Hi there,

I've been stuck on the import into the SYS08 Employee Details Module (Activity 4). When I run the import, I get the error below:

I think this is what's preventing me from sourcing the right answer for Question 5, since the mapping on activity 5 works well for me.

Here's how I set up the Roles list:

and

I've added "Role" as a List line item on the module, and the information populates only partially. After the import, I see data only for "staff members" .

Where did I go wrong here?

Thanks in advance!

Accepted answers

rob_marshall

@AJakote

Why is the line item Role a subsidiary view, meaning it has different dimensionality than the rest of the module? It shouldn't be. Please to back to that line item (Role) and make it have the same dimensionality as the rest of the line items (Applies To should have a -)

Rob

All comments

Kanishq17

Hi @AJakote

What is the source of your load and can you send a snip of the import mapping for role line item

AJakote

Hi there,

I hope I understood correctly the "source of load" as the source file of import for Activity 4 - which is this text file:

When I'm running the import, this is my mapping:

Another weird thing is that the "Leave Date" formatting is blank when I set the format:

As to the role, it's mapped in the following way on the SYS08 module:

rob_marshall

@AJakote

Rob

AJakote

I didn't even observe this was missing - the import worked like a charm now! Inserting a snipped of the solution down here:

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…
Exports with anaplan using informatica connector
I'm trying to execute an Action to export data with the use of a Mapping in Informatica. But it gives us null rows .If we export directly from Anaplan , the export file has all the rows filled. Both exports have same number of rows but in the informatica export the values appear as blank. This issue is with only some…