Query against DFF attribute

Summary

Looking for query to populate value against attribute

Content

Hi Experts,

I have a requirement as follows.

We have created one DFF attribute(say XYZ Attribute) with Campaign Number. In the Manage Values in the Description we have given Description of the value.

Now our requirement is to create one more attribute referring to the XYZ attribute,  and populate only description when HR select any value against XYZ attirbute.

 

Eg:

Campaign number is 678433 and description is Monitoring department.

XYZ attribute will show the values as 678433

New Attribute has to show the description as Monitoring department

this we can do at the value set level for the new attribute. Need your inputs to write the query.