Hi All,
I am using Excel to CDT smart service, and in my excel, one of column lets say Column A contain numbers, format in Excel is Text Only. I am storing this number as Text Datatype in Appian.
Issue is Column A values which is actually number in Excel and mapped to Text datatype in Appian is getting converted to Exponential. I tired using Fixed(), todecimal() and text() function but non of this giving me required output.
Another strange behavior we noticed is, Converting Excel cell to Text worked fine in Development and Test environment but same thing is not working in production.
I checked few of existing post on same issue but didn't find satisfactory answer.
E.g :
Excel cell value : 9122604701,
Appian Converting it to : 9.122605e+09,
Required output as : 9122604701
Regards,
Simple Shah
Discussion posts and replies are publicly visible
Hi Simple,
If you have tried everything and you are not left any other options then you can consider this solution.
1. Create a table in the database with the same columns as the excel spreadsheet.
2. Create a stored procedure which loads the excel into a table. You can handle this text to number conversion more efficiently in SQL.
3. Use "Execute Stored Procedure" smart service and pass the excel as input parameter.
4. Query the required data from the table.
This should fix your issue.
Let me know if it works.
Cheers,
Sidhant Behura