Trying to load from file to module data

antti.kerola@elisa.fi
Contributor

Trying to load from file to module data

Hi Community,

 

I'am developed following dashboard to our end user. My problem is that if I want to load local accounts from a file - all local account will goes ignored state.

 

The module contains a numbered list. My primary key in the module is combination of company+local account number. My question is that how can I import from external files all local accounts instead of creating those local accounts one by one?

 

Antti

1 ACCEPTED SOLUTION

Accepted Solutions
nathan_rudman
Master Anaplanner/Community Boss

Re: Trying to load from file to module data

Every local account will have to exist in your list, at least if they have a different account code.

 

You can cross you account code list with your entities, in which case you would not have to create one for each entity, but rather use the entity code to load the data in the right dimension.

 

In any case, items in list can be created from the load process , load your file in your list and create the account with the code and the name


Nathan Rudman, Anaplan Model Builder

View solution in original post

2 REPLIES 2
nathan_rudman
Master Anaplanner/Community Boss

Re: Trying to load from file to module data

Every local account will have to exist in your list, at least if they have a different account code.

 

You can cross you account code list with your entities, in which case you would not have to create one for each entity, but rather use the entity code to load the data in the right dimension.

 

In any case, items in list can be created from the load process , load your file in your list and create the account with the code and the name


Nathan Rudman, Anaplan Model Builder

View solution in original post

ChrisHeathcote
Community Boss

Re: Trying to load from file to module data

antti.kerola@elisa.fi 

The following link to Anapedia will run you through the process of importing into a list from a text file/csv.

Anapedia is a fantastic resource and should form a key part of your research when you come up against a technical challenge.

Import-Data-into-Lists 

Good luck,

Chris 

Chris Heathcote
Bedford Consulting

Gold Partner and Regional Partner of the Year 2021, EMEA