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
- Create a decision table and add a property set for a text property.
- Enter a 5D (or other numeric string with a trailing D or d) to a cell in some row of the text property column.
- Export the data using the Export button on the Table tab for the decision table rule.
- 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.
Published August 26, 2017 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.