The 2.png is the data in xlsx format and the 1.png is the error image in csv format output
New solution.
When the field value is ="0E141", Excel shows 0E141.
Add '="' to the front of the field and '"' to the back of the field to save it.
Open the CSV by Excel.
Hi @arjundelara,
Can you show you configure the output tool for the Alteryx file? Do you use '|' as a delimiter?
Hi @Emil_Kos
I set the Delimiters to "|" but I am get a single column output . My ouput must have a 9 column.
Thank you!
Hi, @arjundelara
Can you add a Select Tool to manually enforce the Field Type?
You can also use a Muti-Field Formula Tool if you have many columns.
I'm just wondering if you have to explicitly set that to drive the behavior that you need...
When we type 0E148 into Excel, Excel automatically calculate an exponential calculation as 0.
(Alteryx seems to do the same thing in the Text input tool).
When we open a CSV by Excel, it seems to do the same thing.
How about to add '(apostrophe) prefixing the fields that contain 0E148 ?(However, if you open it by Excel, it will be prefixed with '(apostrophe).)
Alteryx
Excel
Hi All,
Appreciate all the suggestions. Thank you so much!.
@AkimasaKajitani
Amazing formula now my exponential data output to csv format is remove.
Great things guys. Hope I'll makes some help of you all.
Cheers,
