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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
#SANTALYTICS

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
SOLVED

Output an Excel formula

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