Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Need help with hierarchy

jagan‌  stalwar1

Hi All

I need some help with hierarchy

I have data like below

FromTableFromFieldtotabletofieldqualifier
Cf1Df2FinalTarget
Cf3Df4FinalTarget
Bf5Cf1qualifier
Af6Cf3qualifier
Pf7Af6beginning
Pf8Bf5

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

1 Reply
Anonymous
Not applicable
Author

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