Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Decision table export changes 5D to 5

SA-42655

Summary



When exporting a decision table to xlsx through the out of the box (OOTB) export functionality cells of the format <numeric> + D (for example 5D) are interpreted as just the numeric portion "5" in the exported file even if the property type of the column set is text. This causes loss of information on import.


Error Messages



Not applicable


Steps to Reproduce

  1. Create a decision table and add a property set for a text property.
  2. Enter a 5D (or other numeric string with a trailing D or d) to a cell in some row of the text property column.
  3. Export the data using the Export button on the Table tab for the decision table rule.
  4. Open the xlsx file and observe the value for that column is changed to 5.


Root Cause



A defect in Pegasystems’ code or rules where the type of the property is not considered for export. The cell's value is determined to be numeric if it's a valid double for the Java language, which 5D satisfies.

Resolution



Perform the following local-change: Use "5D" with the double quotes in the cell to indicate it is a string value.

Suggest Edit

Published August 26, 2017 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

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

Pega Community 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
Contact us