Error with SFTP connector?

[ahanumantharaya]

Hi,

Has anyone tried downloading CSV file using SFTP connector which has scientific value in it? I am unable to convert those scientific values since I am getting value as scientific not numbers. below is the screenshot.
PS: column which has this value are numerical and Alpha numerical values. Workato support is no useful.

Thanks,
Amar

[marlon-muela]

Hello Amar!
This is Marlon from the Support team.

This value typically happens for numbers with a long decimal value. May we know what is the value expected instead of a scientific value?