Importing metadata in separate node types

Content

Hi, 

I am trying to import a metadata file containing two node types i.e. Entity and cost center. In the Entity node type, Entity 1 and ENtity 2 nodes should be imported and in cost center node type, CC1, CC2, CC3, CC4 nodes should be imported. The nodes of the Cost center node type should be the children of the entity node type. This is the requirement. 

But while importing, File is getting imported successfully and I am not getting the required result.

I have attached the file as well for the reference.

Could anyone help me with this?

Thanks