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).
Discussion posts and replies are publicly visible
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?
Is this an issue with the excel column not being formatted as integer?