Parent Child Mapping Error

Prashant22may1

Hi,

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.

DavidSmith

@Prashant22may1 

Depending on your data and the unique key there are a few ways to do this, but yes you could check for this before importing into the target list

a. You could create a numbered list under the parents list so the "child" is present under multiple parents

b. Create a module by this "child" list with a single line item (count) with a formula of 1

c. Create a flat list of children along with a module mapping the "child" against the list from 1a.

d. Use a sum formulae to sum the count from 1b to see how many occurrences there are

e. Filter on the count >1 for those with multiple parents to highlight the problems

 

You could also bring the transactions into a staging module and do a similar check above before importing into the target list

 

Hope that helps

David