Delete orphan records from a Properties module
I want to change the rollups of Cost Center into its parent Division in hierarchy (i.e. Cost Center 100 belongs to Div 1 today. I want to change to Div 2).
I can make teh change and write the data correctly. But I can't think of an automated way to delete 2 levels of hierarchy under the existing cost center. (i.e. Employees belong to Cost Center. All employees rolling up to Div 1 should now go to Div 2). When I build the new mapping and delete the old cost center rollup, everything underneath it gets orphaned (as it should). But my data is doubling since I now have 2 records.
Does anyone know how to just delete orphan records?
I did a ISBLANK(PARENT(Item) in the Employee properties module. But when I have orphan records, it doesn't show in the module at all. It only shows what's in hierarchy.