Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Pavan Kalyan Avisineni (Pavan_kalyan)
Evoke Technologies
Senior Software Engineer
Evoke Technologies
IN
Pavan_kalyan Member since 2019 7 posts
Evoke Technologies
Posted: Sep 29, 2021
Last activity: Oct 21, 2021
Posted: 29 Sep 2021 9:00 EDT
Last activity: 21 Oct 2021 3:28 EDT
Closed
Solved

Integer, decimal type properties are getting stored as text in excel generated from pega.

Properties which are of integer or decimal type are getting stored as text in excel generated from pega. Even though they are of type number, they are getting treated as text and coming with a green triangle in excel. How to avoid this conversion to text?

***Edited by Moderator Marissa to change type from Pega Academy to Product, update Capability tags****
To see attachments, please log in.
Pega Platform 8.2.2
Pega Cloud
Data Integration
User Experience
Government
Senior System Architect

Posted: 3 years ago
Posted: 30 Sep 2021 15:19 EDT
deivit mamani (Deivit)
Rulesware

Rulesware
PE

@Pavan_kalyanSo, are you using the {.property input} syntax? If so, then it also happened to me. The values were treated as text in the generated excel.

What I did was to create a hidden sheet in the excel were I put all of the properties I want to map, then in the main sheet I used a function like =INT or =ROUND to translate it to numbers.

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice