Preparing Hierarchy/Lineage data for Sankey Chart

Hi, try this

Table = UNION(SELECTCOLUMNS(table,"Source",Layer 1 column,"Target",Layer 2 column),
                         SELECTCOLUMNS(table,"Source",Layer 2 column,"Target",Layer 3 column),

                        SELECTCOLUMNS(table,"Source",Layer 3 column,"Target",Layer 4 column),

                        SELECTCOLUMNS(table,"Source",Layer 4 column,"Target",Layer 5 column)

                    )

It works great. Thanks for your response... The Exact code i used is given below.

---

Sankey = UNION(SELECTCOLUMNS(Test,"Source",[Layer 1] ,"Target",[Layer 2] ),

                         SELECTCOLUMNS(Test,"Source",[Layer 2] ,"Target",[Layer 3]),

                        SELECTCOLUMNS(Test,"Source",[Layer 3] ,"Target",[Layer 4] ),

                        SELECTCOLUMNS(Test,"Source",[Layer 4] ,"Target",[Layer 5] )

                    )