Arpit I need one more clarification here:

1. How about Work Step code and name at all? Is 23560.1 a Cost Code or a Work Step (Code) for you?

2. Do you care about Cost Code Name? Or the Code is good enough for you.

Thank you!

@Guest still looking for a quick answer to my second question. Could you please respond at your earliest convenience?

Bentley team,

Thank you for the workaround! It works if there is a limited number of known Cost Codes. A typical project has about 300+ codes, which will be a challenge to write and run the scripts for. I will give this a shot nonetheless and see if the system will hold up :D

@Guest Two follow-up questions from me
1. Was the provided workaround acceptable?

2. Your scenarios and example provided here - the selected element has more than one cost code assigned, and each with a different quantity, correct?

Hi Arpit,

Thanks for your time this week to discuss the ideas. I’ve reviewed the concept again and have written the scripts that can reorganise the data based on your requirements.

These scripts need to be applied to Resources.

10.01.02.001 - cost code from Modeler

Cost Code 1 -new UF

Cost Code 1 Quantity -new UF

RESOURCE( EXIST UFV("10.01.02.001") ) ASSIGN_UF("Cost Code 1 ", STRING, ("10.01.02.001"))

RESOURCE( EXIST UFV("10.01.02.001") ) ASSIGN_UF("Cost Code 1 Quantity", FLOAT, UFV("10.01.02.001"))

Kind Regards,

Maria