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

Aditya1993

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

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