Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
8 subscribers
Views
2005 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I am using Parse Excel Spreadsheet to CDT smart node(To upload excel data in to
sivam
over 8 years ago
I am using Parse Excel Spreadsheet to CDT smart node(To upload excel data in to DB), in the excel having a column "ID". In this ID column I am passing numbers length 9. While reading in the process model using Parse Excel Spreadsheet to CDT smart node, the numbers are converting to exponential value if the number length is more than 7.
Example: 12345678 (Excel column value) ---- 1.234568e+07 (process variable value)
Thanks.
OriginalPostID-172580
OriginalPostID-172580
Discussion posts and replies are publicly visible
Parents
0
siddharthm
over 8 years ago
Hi Sivam. Even we were facing this issue . I believe this expression will help you in retaining the excel column value - fixed(todecimal(ri!value),0,true).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
siddharthm
over 8 years ago
Hi Sivam. Even we were facing this issue . I believe this expression will help you in retaining the excel column value - fixed(todecimal(ri!value),0,true).
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data