1 Reply Latest reply: Nov 8, 2016 1:28 AM by David De Wilde RSS

    Need help with hierarchy

    anusha vemuri

      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