I need some help with hierarchy
I have data like below
I have to map columns across qualifiers
here based on the qualifier FinalTarget is the Target table
so D.f2--C.f1--B.f5--P.f8 so column "f2 in table D" is coming originally from "f8 column in table P"
sameway D.f4--C.f3--A.f6--P.f7 so column "f4 in table D" is coming originally from "f7 column in table P"
Can we achieve something like this
There is a very good technical brief on this Hierarchies
In the end of the pdf there is an example with a great explanation how to use this.
For your case you should use tofield as NodeID and fromfield as ParentID in this example.