Alteryx Designer Desktop Discussions

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

Google Drive Output to gsheet with line breaks

GerritB
5 - Atom

Dear Community,

in my workflows I have cells which include line breaks. I would like get them to written to a gSheet. With the old "gSheet Input / Output" it worked. Now, with the Google Drive Output, line breaks lead to multiple rows which destroys the whole sheet formatting.

 

I already tried something like (Attribute1 contains a linebreak), but it did not work: 

Replace([Attribute1], '\n", CharFromInt(10))

 

This actually worked, but i would prefer text instead of writing gSheet formular to a sheet: 

'="a"&CHAR(10)&"b"'

 

Any advice?

0 REPLIES 0
Labels