xlsx format output correct but if set to csv format no the same

[arjundelara]

The 2.png is the data in xlsx format and the 1.png is the error image in csv format output

[Emil_Kos]

Hi @arjundelara,

Can you show you configure the output tool for the Alteryx file? Do you use '|' as a delimiter? 

[arjundelara]

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!

[RobertOdera]

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...

[Qiu]

@arjundelara 
My experience is just use the default delimeter semicolon and the Alteryx will do the rest.
If you can share your packaged workflow, we would like to take look at it.

[AkimasaKajitani]

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

 

[AkimasaKajitani · Accepted solution]

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.

[arjundelara]

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.

Thank you!

Cheers,