Question
Etisalat
AE
Last activity: 1 Dec 2023 1:19 EST
How to display static content as well property value in one cell using excel template
I want to display a static field as well as a property value in a single cell in excel.
For example:
"Name: {OperatorID.pyUserName input}" in one cell.So output should be " Name: Madhu "
I have around 80 fields to be shown similarly.
So, formulating the data before generating the excel is not something I am looking for.
Pegasystems Inc.
GB
@MadhuchhandaC16946312 You can achieve this by using the CONCATENATE function in Excel or by using the '&' operator to join the static text and the property value. In your case, you can use the formula "Name: " & OperatorID.pyUserName in the cell. This will display the static text "Name: " followed by the value of the OperatorID.pyUserName property in the same cell. Please note that you need to ensure that the property value is available in the context where you are generating the Excel file.
This is a GenAI-powered tool. All generated answers require validation against the provided references.
How use current operator name as input in drop down
Etisalat
AE
@MarijeSchillernI tried giving as below:
This doesn't seem to work. Please let me know if it should be written in some other way.