Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I need some help with hierarchy
I have data like below
FromTable | FromField | totable | tofield | qualifier |
---|---|---|---|---|
C | f1 | D | f2 | FinalTarget |
C | f3 | D | f4 | FinalTarget |
B | f5 | C | f1 | qualifier |
A | f6 | C | f3 | qualifier |
P | f7 | A | f6 | beginning |
P | f8 | B | f5 |
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
Hi,
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.
Kind regards,
David