Getting problem in Parse Excel Spreadsheet to CDT smart service

bhanuprakashm over 7 years ago

Hi All,
I am using "Parse Excel Spreadsheet to CDT" smart service..when i was upload the excel one of the column values contains "800001058" ,"800001058","800001058" like this.

so i am stored this values into text datatype column in cdt..but it coming like "8.000011e+08" from smart node.(before storing into db)

Can you please help me in this..

Discussion posts and replies are publicly visible

0 kondetiv over 7 years ago

can you open your excel sheet and right click on the corresponding cell and select format cells option. Now you will get one window. In that window select number tab and select category as text. Now do this for all the cells in that column. Give a try and let me know. PFA for example.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 marcoc918
A Score Level 1
over 7 years ago

try saving this value not in a text datatype but on number(decimal)/float field
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 ashman over 7 years ago

Hi Bhanuprakashm, Below thread can help you to resolve this issue
forum.appian.com/.../e-239024
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kumara0002
A Score Level 1
over 7 years ago

Format the data in excel sheet it self before uploading into appian.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jasmins over 7 years ago

Hi bhanuprakashm, while saving the value in text field of CDT you can use this function for that field cleanwith(fixed("800001058",3),"-0123456789.") , it wont convert the value in exponential.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
+1 bhanuprakashm over 7 years ago

Thanks, my issue is resolved..
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Reject Answer

Cancel
0 Mihai-Octavian Tudose
Certified Lead Developer
over 6 years ago in reply to bhanuprakashm

Hello, can you please give me some input into how you were able to overcome this issue? Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 chandu
A Score Level 2
over 6 years ago in reply to Mihai-Octavian Tudose

I would like to suggest the solution provided by Venkat Kondeti is good one, One more way is like select the entire column and format the cells to Text and save the excel sheet instead of formatting each cell. Saving this type of values in text is good approach.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel