Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

how to keep the "newlines detected..." in output files

margautz
5 - Atom

Hello All,

 

I am quite new in playing with Alteryx and I am wondering if it is possible to keep the "newline" in xls files.

 

I have an input like

 

productcolor
applered
pearred

 

I would like to have it like

 

productcolor

apple

pear

red

 

Let's say a concatenation using a "newline separator".

I did it, but once I run the flow, I have the message "newlines detected in data output file might not be readable by other tools" and actually xls file does not recognize the separator and retur a concatenation like

 

productcolor
applepearred

 

Any idea how to export the "newline"?

 

Thanks a lot for your time!

 

Best,

Margherita

2 REPLIES 2
Thableaus
17 - Castor
17 - Castor

Hi @margautz

 

Just enable the "Wrap Text" option in the cells within your Excel generated file that it's supposed to work fine.

 

Cheers,

newuser980345483
7 - Meteor

I am looking to do something similar, however, my output is a Tableau server, not xls. Any advice on accomplishing this? It is appearing as a tab in Tableau. 

Labels