Number format being changed when importing between models

I am attempting to set up an import between modules in two models; the target module has a has a list of numbers as the 'applies to' while the souces has a list of business areas.

To get around this I have created a line item in the source module to assign each entry a number reference.

This number is formatted at zero decimale points, so it matches he list in the target model.

The issue is, when I try and import it is stating that the number from the source module is to 1 decimal point, and as such it won't match the target - see attached image.

I'm sure there's probably something obvious I'm missing and any advice would be appriciated

Import_issue_38912.png

Import_issue_2_38912.png

Accepted answers

harish_bk

Hi Ceri

If you are not using the number formatted line item for anything else, then you can directly format that line item to text and load the numbers or submit the numbers there.

I know its bit of pain but this is the work around we could come out with.

All comments

harish_bk

Hi Ceri

Line item 1: 1.0, Number Format

Line item 2: 1, Text Format, Formula: Text(Line item 1) and use Line Item 2 for the imports.

Hope this helps

CommunityMember83188

The work around did the job, thanks - though slightly annoying that it happens in the first place, not particularly conducive to model efficiency.

harish_bk

Hi Ceri

If you are not using the number formatted line item for anything else, then you can directly format that line item to text and load the numbers or submit the numbers there.

I know its bit of pain but this is the work around we could come out with.

DavidSmith

@CommunityMember83188

@harish_bk

Cheat tip!!

Set the code of the ID list to 1.0, 2.0, 3.0 etc

This will then match automatically

You can always reference the NAME in formulas if you are needing the 1,2,3 reference

Hope this helps

David

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…