nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

L1 Model Building - Lesson 7 Data Mapping issue

fgeraldo

I was able to import everything but the formula CODE(ITEM('E2 Employees#')) does not seen to be working. I see everything correctly EXCEPT data in Code line. Any ideas? I already tried saving the downloaded file with opening.

Accepted answers

Akhtar.shahbaz

Hi @fgeraldo ,

Can you please check your 'E2 Employees#' list whether the code was imported properly or not?

Please share some screenshot

Thanks

Akhtar

All comments

fgeraldo

Meant to say withOUT opening file in Excel.

Akhtar.shahbaz

Hi @fgeraldo ,

Can you please check your 'E2 Employees#' list whether the code was imported properly or not?

Please share some screenshot

Thanks

Akhtar

sobaid

Hi,
Code is logic based line item and has nothing to do with imports/excel file. If your lineitem is accepting the formula then check for E2 Employees# List as @Akhtar.shahbaz suggested! Hope it does the work
Thanks.

fgeraldo

Good morning @Akhtar.shahbaz ,

I checked 'E2 Employees#' list and the code was not imported. I imported the code and now it works. Thank you!

-Freddy

Quick Links

Can you help?

Unanswered questions

Anaplan Analyst performance on large, sparse models
Has anyone tested Analyst’s response quality/speed on large, sparse models (think 10+ dimensions, millions of line items)? Wondering if there’s a practical ceiling before it starts timing out.
Anaplan ⇄ Google Sheets pivot tool — feedback welcome
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
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.…