Skip to main content

Hi All,

Flatten transformation of a recipe returns the multi value field "Hierarchy Nodes Column " with comma separated Ids of all the parent nodes.

I want an other field which contains comma separated Names of those parent node Ids.

Can you help me with an approach to do this.

 

For example:

I have an Account Hierarchy which was flattened in the recipe resulted as shown below.

How to get Names, instead of Ids of all Hierarchy nodes in Flatten transformation of a recipe in CRMA ?Hierarchy Multi Field has 3 parent Account Ids for the selected Account.

 

Similarly, I want an other column next to it having Account Names of those 3 Account Ids, separated by a comma in the same row.

1 个回答
0/9000