This is a import file in anaplan, i have to create a Parent child relationship with Unique identifi

Aditya1993
Aditya1993
in Modeling

This is a import file in anaplan, i have to create a Parent child relation ship with Unique identifier as child and Area code block number as parent and then rest of the attribute also be under the child

Unique identifier

Attibute 1

Attibute 2

Area Code Block Number

429393_ABC

Customer A

0.2

MC300

219201_ABC

Customer B

0.4

MC300

330530_ABC

Customer C

0.5

MC300

539763_ABC

Customer D

0.7

MC300

859866_ABC

Customer E

0.7

MC300

968995_ABC

Customer B

0.8

MC300

1272638_ABC

Customer A

0.7

MC300

Answers

  • jagadishdash
    jagadishdash

    https://community.anaplan.com/profile/Aditya1993

    Multiple ways to do it.

    1. IF you have already created the Area code list and Unique identifier list then You can directly import into the list, First into the Area code list where only are code will be mapped. Then into unique identifier list where unique identifier will be mapped and parent as area code. This is a direct way to do it.
    2. But as a best practice, You can created a stagging module and import whole file with a placeholder list and store all the data, then do isfirstoccurance for area code and mae the saved view and import the saved view into the module, again do a saved view for unique identifier with the parent column to it. and import to the unique identifier list. and you can create a system module for unique identifier and bring attributes from the staging module by unique identifier.

    Hope it helps.

    Thanks

  • SriNitya
    SriNitya

    @Aditya1993
    if you have data hub model create a system module store the complete data, then do isfirstoccurance on area code and then apply filter and create a saved view for Area code and another for unique identifier with parent and other attributes. using the views populate the data to respective lists in Spoke Model.

Categories