I have an unique issue which requries a uinque..
Lets say I have a List called - "Scenarios"
Using the list in a module called "Data Scenario"
I want to copy data of Net Sales from Scenario 1 to Scenario 3, I know I can use the import action, however in that case, I will have to manually map the scenarios. (1>3)
Is there a way to copy data from 1 scenario to another without the manual mapping in the Import action. Lets say, if we want to provide option to the user to create scenarios in future independtly & also copy data from one to another.
You can create 2 more line items in same module,
- same scenario list formatted line item - 2nd line item
- Number format line item - 3rd line item
User will select Scenario 1 against scenario 3 in 2nd line item - that'll mean user needs to copy scenario 1 data to scenario 3
Apply formula in 3rd line item: Data[lookup: 2nd line item]. That'll pull 5000 in 3rd line item against scenario 3 and then , based on a filter logic you can create an import to import data from 3rd line item to 1st line item