Derive Value from the Department Tree in Compensation Worksheet

Summary:

Hi Team,

We have a requirement to fetch Value from different node in the Department Tree in Compensation Worksheet.

Has anyone achieved it and how? Is it feasible?

We have data from 3 fields Division, Brand and Department (Source) in the Fusion Department field (Target).

The department tree has lowest node as Brand, one above it is Division and the final node above it is Department.

We have these 3 fields as separate in Worksheet Columns (Custom User Defined Columns) , As we cannot use the department field as it as data from 3 fields from the source in the target

Kindly let us know if it is feasible and how?