Get rid of scientifc notation in exported CSV

Question

Hello,I'm using Export Data Entity to CSV smart service. This gives me CSV output and the CSV has a column named TransId, this column/field is a varchar in Appian.It may contain text and/or sometimes just integer numbers more than 11 digits.The problem here is when the value of this column is more than 11 digits then CSV by default shows value in a scientific format like 1.12233E+13 until the cell of the CSV is formatted to Integer.Is there a way to get the value correctly by default?(This smart service does not have input to take template unlike 'Export CDT to Excel' smart service).

jakee0001 · Answer

Ther export to DSE is gonna be the issue here because you cannot do any data transformation before export.  Varchar is for strings so I think its casting the large integer to a string.  You would want to call something like fixed (if you knew the number of decimal places) for the output to be in text format, but export to DSE doesn't work.  I think since your CDT matches your DB column which is varchar but is actually storing an int or double, you have issues.  Can you create a new exportCDT with field type of integer and see if that works?

Sign up

Login with SSO

Login to the community

Login with SSO