Import from Numbered list module

I am trying to import from a module in a model which has weeks as a numbered list, into a module in a model which has weeks as its timescale. I cannot get the import to recognise the dates from the source module, and assign to periods in the target module. Is this possible?

Accepted answers

ryan_kohn

1. Make sure you are not using the NAME() function to get the code. The NAME() function for a numbered list returns the #ID.

2. If you've updated the import source and it's still not showing the right fields, make sure you have updated the saved view to include your new field. If it still doesn't show, try deleting and re-creating the import.

All comments

JaredDolich

@danieldridan

Try using the CODE of the Week and convert it to a TEXT format that Anaplan will recognize as a WEEK in the calendar OR convert the CODE to TEXT that looks like a DATE that is within the week. Create a saved view with this line item and use it to map to the calendarized week module. Will work.

Convert CODE to Week | Week [#] FY[YY] | Week 1 FY22
Covert CODE to TEXT as a Date | 1/31/2022

danieldridan

Perhaps I did not explain the problem correctly.

Importing from Model 1, to Model 2.

Model 1.

Timescale = Months

Source Module uses a Numbered List (week) for time.

Line item = volume (number format)

Model 2.

Timescale = Weeks

Target Module has Time as a dimension.

Line item = volume (number format)

I need to map the values in the 'volume' line item from the module in Model 1, to the module in Model 2.

The import just sees the numbered list value (e.g. #1, #2 etc) in the Weeks, and does not know how to map it to the time periods.

I created a line item in the source module, which displays the week list code as text. That didn't work. The import still does not recognise this.

Misbah

@danieldridan

It depends how are the weeks in your source module named as. Assuming they are named as WEEK 1 FYXX. You could perform this import in such a way that In your source module create a line item which refers the display name of your numbered list. Use this line item to map with the target module

By the way, this week list should not be a numbered list because you wouldn't be having repetitive weeks in the same list.

Misbah

Miz Logix

ShubhamCh

@danieldridan

As far as I can understand the problem, I think you need to create one line item which is text formatted and shows values exactly as the display names of the numbered list (weeks).

In mapping, use this newly created text formatted line item and map volume to the volume. If needed you can specify the week format also while importing.

I think it should work if I understood the problem correctly.

Thanks!

-Shubham

ryan_kohn

1. Make sure you are not using the NAME() function to get the code. The NAME() function for a numbered list returns the #ID.

danieldridan

Great tip! This is what I was doing wrong. Couldn't work out why the proposed solutions would not work!

The extra line item converted to TEXT (not using the 'NAME' function) and mapping to that line item did work.

Ended up using the below formula to convert the date format of the time period to convert it to TEXT.

TEXT(MONTH(DATE FORMAT)) & "/" & TEXT(DAY(DATE FORMAT)) & "/" & TEXT(YEAR(DATE FORMAT))

Thanks!

ryan_kohn

Nice work @danieldridan! As an additional tip: since that formula involves text and text concatentations, you should put that in a System module dimensioned only by the time period. This will minimize the impact of those heavy calculations.

Quick Links

Can you help?

Unanswered questions

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.…
CERTIFICATION BADGES - ANNOUNCEMENT
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385