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

Output an Excel formula

yozveren
6 - 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

3 REPLIES 3
BenMoss
ACE Emeritus
ACE Emeritus

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

 

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

yozveren
6 - Meteoroid

Was a stupid question after all.

 

Thank you very much!

PaulN
Alteryx Alumni (Retired)

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