Create a list out of on data inputs

FlavieBR · 2023-02-03T05:01:34+00:00

There was an error rendering this rich post.

Hello Community,

I am quite new to ANAPLAN so a bit lost sometimes and not all knowledgeable yet!

I have created a simple list of numbers (#1, #2, #3…) to allow our users to input data into a table (inputs module), in different fields.

After the data is in, a line item picks up a final description with a concatenation and I would need all the results of this line item to become a new list that I then use in another “calculation” module. Is that possible?

If not, the calculation module takes again the initial list of numbers but it’s meaningless without the text previously entered in the input module.

I hope my question reflects clearly what I am trying to do…

Thanks in advance for the help!

Flavie.

Accepted answers

All comments

skarki

Do you have any example so that it would help to understand problem concisely. based on what you describe it is possible.

once line item picks of description , you can create view
create import action to load from view into list
and use list in calculation module

Thanks,

FlavieBR

Hi Sharki,

Thank you for offering your help!

So I have a list of simple numbers (#1, #2, #3, etc) which is used in a CAPEX input module.

In that module (which also applies to cost centres), I created several line items allowing the users to do the following for each list number:

choose a category
give a succinct written description
enter the capex amount, dates of cashflows, etc.

Then another line item picks up category & description into a concatenation. And that is what I want to eventually become a new list for the next calculation module.

But one cost centre will have data from number #1 to #15 while another may have only one entry.

Does that help understand what I want to do?

I don't know what a create import action is...

Let me know if what I have in mind is feasible, thank you!

Flavie.

skarki

Thanks for more detail explanation. As you mentioned one cost center can have multiple list numbers in CAPEX module, cost center can be considered as parent, right? Does your new list will also have cost center as parent?

yes it is possible to move line item data into new list through action.

FlavieBR

Hi, yes ideally the new list can depend on cost centre as parent.

MaraCedeno

Hello! I would like to know if you solved this question and how!

FlavieBR

Hi @MaraCedeno, unfortunately not. I had to manage otherwise and rethink the initial design I had in mind. I think the solution described would be possible though, but back then I was too new to Anaplan to even understand what they meant!

Quick Links

Can you help?

Unanswered questions

Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…