cancel
Showing results for 
Search instead for 
Did you mean: 

error on creating hierarchy field

Former Member
0 Kudos

i was working with the challenges in the import manager, where "create hierarchy field" is a feature of import manager,

the problem i was facing when i was creating the hierarchy field is that

the source data i 've taken here microsoft access file. I selected two fields from the source and right clicked on it. i had "create hierarchy field" as an option, now after clicking on it, i gave all the parameters that has to be given like hierarchy name, parent node and child node, when i clicked "ok" button , it gave an error which said "unable to create hierarchy fields"

can anyone help me out with the correct way of dealing with the "create hierarchy fields" option?

thanks in advance

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi Vinod,

It seems like you have 2 different fields namely address and city and thus u r finding it dificult to form hierarchy.

I suggest you can create your hierarchy in the data manager.

For the source table, you can first create the patition and heirarchy in the second tab Partition Field/Values in the import manager and then map it to the required hierarchy.

Hope that helps.

Regards,

Tanveer.

<b>Hope that helps.</b>

Former Member
0 Kudos

Hi Vinod,

Obviously using taxonomy would be easier.But when partitioning heirarchy has wider scope compared to taxonomy.

regards

Vinay

Former Member
0 Kudos

Hi vinod

destination heirarchy you decide and make in Data manager.In import manager the source fields you are taking and want to build heirarchy upon, just split them by delimiter like ';' or 'space' or '\' etc.Like if source field you are taking as 'Country;city;street' use split to heirarchy using ';' as delimiter.Aheirarchy coutry->city->street will be created.Import manager will create the required heirarchy.Then in value conversion and mapping just map this source heirarchy created with destination heirarchy you created in Data manager.

Please feel free to ask further.

Please mark helpful answers

Reards

Vinay

Former Member
0 Kudos

Hi,

there are several ways to create hierarchies in Import Manager. It would be helpful if you could give more information on the source data, like what's in the source fields you want to use to create the hierarchy. Is it the hierarchy level and the key?

Cheers,

Chris

Former Member
0 Kudos

Hi,

Thanks for the reply....

I can provide u an example.....

i have two fields named "address" and "city" both of which i wanted in a hierarchy with the name "location", so if i wanted to create a hierarchy where the parent node is "city" and child node is "address", and the hierarchy name is "location"

You can refer "import manager reference guide, page number : 24, with the challenge : "Combine two fields to build a hierarchy"

regards

vinod

Former Member
0 Kudos

Hi Vinod,

I had the same problem when trying to rebuild your problem.

What might work as a sort of 'workaround' is using a taxonomy table instead of a hierarchy table.

When in Import Manager select the location table and then chose the 'partition fields/values' tab where you can use the cities to partition your source data, then import into the Taxonomy table.

Let me know if this works for your case!

Cheers,

Chris