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

2 REPLIES 2
nathan_rudman
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
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