I'm trying to load master data in the system but in the files which I trying to load have erroneous records like one child has multiple parents. So is there any work around in which I can identify those combinations in a staging module for error check in anaplan.
This could be the way when this multiple parent mapping occurs at last level, but there are 7 level of hierarchy & this multiple parent record can be at any level. So can there be a work around for this.
You will first need to create a flat list of "all" parents and ensure that the lists includes all potential parents for each level. you should be able to create this from the file by referencing the "parent" field
you will then be able to bring the children in under the parent, so the child will appear under the respective parents
Then the sum I described will be able to count the occurrences