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