Delete data from Numbered List No parents

I created a module and process to delete all the data from Numbered list. it works fine to delete the data however there are some data (no parents, just code) which I am not sure how those got into the list are still there(I believe because of the mapping eror). Also, on the delete module, these data dont show up but those data into the list. Please see the attached pic for reference. I need to fix this asap. Thanks for the help

Setting_121115.JPG

data_121115.JPG

Accepted answers

rob_marshall

@akibulmn

Ok, in that situation, in your delete module, create a line item IsBlank(parent(item('L10')))...this will return a boolean where you can use the "Delete from List using Selection".

Rob

All comments

rob_marshall

@akibulmn

The data that is still there is from the parent list, in your case the Location list. If you want to delete all members in L10, then you will need to delete the "detailed" members of L1 through L9, that is assuming you have 9 lists that are parents. But when you do that, just know it will delete all data in all modules associated with those lists.

Rob

akibulmn

@rob_marshall Thanks for ur quick reply. Yes I have the same issue in the L10 , And only L10 &L11 has a bunch of data with no parents only ID. I just want to delete the data which dont have any parents on L10; Is there any way to do this? Thanks

rob_marshall

@akibulmn

Ok, in that situation, in your delete module, create a line item IsBlank(parent(item('L10')))...this will return a boolean where you can use the "Delete from List using Selection".

Rob

akibulmn

@rob_marshall
I tried that but for some reason , those data DONT ( which have no aprents just code ) show up in the module . But those data show up in the list. I am not sure why those data which don't have any parents dont show up in the module.

akibulmn

Fixed , the data wont show at the module but i am able to delete those from delte action . Thanks @rob_marshall

Quick Links

Can you help?

Unanswered questions

Create a Filter to show all the elements of that level based on selection in hierarchy
Hello Community members, Requirement Details: I have 5 levels of composite hierarchy list (A1, A2, A3, A4, A5). I have published a module in UX, Now the requirement is If user select a list member from A4 level in the context selector or Custom Filter I have to display all the list members under that A4 level. How can I…
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…