Hi All,
I was trying to import a list from another but came to know that when i add an item in source list it gets reflected but if i delete an item in source list it does not gets reflected in target list.
is there any way to implement that part?
@abhay.kanik
It is not best practice to import using a list is a source, it is much better to use a module and using a module will help here
1. Create a module dimensioned by your source list, and create two boolean line items; Reset and Import. Set the formula for Reset to FALSE and Import to TRUE
2. For your target list, set up an equivalent module with two boolean line items; Imported? and Delete?. The formula for Delete? is NOT Imported?
3. The import process now requires a few more steps
3.1 Import to the list form the source module
3.2 Import the Reset Flag to the target module (targeting the Imported? line item).
3.3. Import the Import Flag to the target module(targeting the Imported? line item).
4. You can now see that the Delete? flag shows those that were not imported
5. Set up a Delete from List action using the module above
6. Run the Delete action
7. Add all of the import and delete steps to a process
I hope that helps
David
Hii
This solution is working, but is there any way for deletion of list item in source module could reflect in the target module without importing the whole list into the target module?
@1434448 ,
Instead of having the formula above as David stated, you could import a boolean of True to the Delete module in the target and then run the action to delete those selected members.
Hope this helps,
Rob
@benfleck
The reset flag is used at the start of the import process to copy to the Imported? line item. At that point all list items are showing as false, so when the file is imported, the TRUE flag is populated.
You need to have the Reset to ensure any items imported previously, but now not in the file are cleared
Hi
You can also achieve the same thing with the help of a delete action and FINDITEM function.
You want the item that is deleted from the source list to be deleted from the target list as well, this can be achieved by using the following.
1. Create a Module , add the target list as a dimension.
2. Create a boolean formatted Line Item in the same module called 'delete'.
3. Use the formula for the boolean as NOT FINDITEM(<Source List Name>, NAME(ITEM(<Target List Name>))).
The above boolean will be true for all the List items which are there in the target list but they are not in the source list.
4. Create a delete action using the boolean you just created and add the action in a process before you run your import . The first action in the process should be your delete action and the second is your import.
Hope it helps.
Thanks
Aakash Sachdeva
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
