community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Output an Excel formula

Highlighted
Meteoroid

Hello,

 

My question might sound stupid, but here I go.

 

Once the Alteryx Excel file Output comes, I would like that the Excel cells of a specific column from that file reads: =TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")

 

So I create a formula in Alteryx, create the column, and copy paste the expression in the formula and then put " " at the beginning and the end:

"=TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")"

 

However, Alteryx naturally considers the " in order, instead of only taking into account the first and last one.

 

How can I make this work ? Basically, how can we write " in a formula ?

I hope that my question is clear, let me know if not.

 

Thank you

Alteryx Certified Partner
Alteryx Certified Partner

You can write " as text by using single qoutes instead as the value that starts and ends text.

 

'=TEXTE(B8&" - "&C8&" - "&D8&" - "&E8;"")'

Meteoroid

Was a stupid question after all.

 

Thank you very much!

Moderator
Moderator

Hi @yozveren,

 

Thank you for posting.

 

You may replace the external double quotes by single quotes.

 

formula_single_quote.png

 

Kind regards,

 

Paul Noirel

Sr Customer Support Engineer, Alteryx

 

 

 

Labels