Need help with hierarchy

[#1]

jagan‌  stalwar1‌

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

[Anonymous]

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