How to make a numbered list to populate another numbered list increasing its size?

Hi everyone,

Anyone knows how to submit data from a numbered list to another numbered list (with the same dimensions) by adding lines to that other list? Both lists are numbered because their items have no identifiers such as code or name.

The idea is to have an initial list that is blank that users fill out, and once they have filled it out they click a button and submit that information to another list, and the initial list is blank again to be able to add new inputs.

The number of lines in the second list must increase according to the number of filled lines in the first list. For example, if the first input contains the numbers #1 to #8 and the second input contains the numbers #1 to #4, it is expected that the second list will contain values #1 to #12.

Does anyone know how to do something like this?

Thanks,

João

Accepted answers

sobaid

1.Basically you need a numbered list called staging list populated with say 100,10000,or even a 100000 the larger the better,
2 Then dimension a module called (Staging module) based on this list (create desired line items and fill them or give an export option for a user to export and import back).
3. Create one more line item and write the formula to get the index number of the list which will come as #1,#2, write logic to make this index numbers as 1#,2#,3#.... (call it as index code).
4,Create a saved view with index code and import into the code of a new numbered list say main list.
5.In the staging module,create another saved view with the index code and line items you want and import it into an new module say Main module dimensioned with the main list based on the code.

6.Lastly create a delete action for the staging list.It will work as per your requirements.
6.You need two lists and two modules for this
Please reach out if you have more questions! 😉

All comments

sobaid

It is possible! ; )

sobaid

6.Lastly create a delete action for the staging list.It will work as per your requirements.
6.You need two lists and two modules for this
Please reach out if you have more questions! 😉

jncardoso

Thank you so much!

Quick Links

Can you help?

Unanswered questions

Create a Data Hub from scratch.
I'm new to Anaplan and would like to understand how to create a Data Hub from scratch. What are the best practices I should follow, and what are the key steps involved in building a Data Hub model? If there are any official documents, learning materials, or links that can guide me through the process, I would really…
On demand Model building courses - check my work
Good afternoon, Is there any place in anapedia where I could check my work? If it does not exist yet, may I suggest to create this area somewhere in the plat-form? With all my respect, it is a non-sense not being able to check if the line items written are correct or not and stay stucked in the middle of a course. About to…
Fiters in dashboard
Hi, I'm trying to find filter context in dashboard to create filters like attached snapshot 1. But I don't find it. Can someone help me where i can i find filters to create?