Hi,
We are having a requirement to replace true/false value with yes/no and substring function in Excel report in pega, So we are making use of binary file for excel template in pega, But unable to provide excel functions in it, Please can anyone guide how to use function or workaround for it.
Can you perform True/False → Yes/No conversion or substring extraction in the Report Definition or Data Transform?
No Anand, Actually all the data is there in the clipboard, we can manipulate the data in Data transform but we need to introduce new properties to store them, thatswhy if we can manipulate the data directly in the Excel would be better