How to Split A Parent with Many Child List Members?

HarunT

Hello All,

I have a parent list with 135 child list members, and we want to split the child sites into two group with half with the current parent and the remaining half with a new dummy parent. We are not able to split them in the data source, so it will continue to be loaded under the current parent item. Instead of a split, I tried a Boolean with the child sites and aggregate them separately, but it requires altering so many line item formulas, and we do not want to go that way since it would alter many formulas for over a thousand parent items for one single parent. I was wondering if any of you have similar cases and a practical solution. Thanks

Sai_Bharadwaj_Venati

My suggestion would be to update in hierarchy only. If you're unable to do it from source that is fine, you can use the Boolean to reupdate the parent or ignore updating parents for these 70 child members from source

Alternatively you can write some formula to update parent in source import itself