Hi Team, Seeking your help to make "=" as the start of the excel record, not sure it is possible or not. Input IDdata1data2Tool formula 1123455+123+4552222345x222x345 Output in excel: IDdata1data2Toolformula 1123455+=123+4552222345x=345x345

Insert Equal Sign as prefix into excel output

Hi Team,

Seeking your help to make "=" as the start of the excel record, not sure it is possible or not.

Input

ID	data1	data2	Tool	formula
1	123	455	+	123+455
2	222	345	x	222x345

Output in excel:

ID	data1	data2	Tool	formula
1	123	455	+	=123+455
2	222	345	x	=345x345

Input

Output

Help

Accepted answers

dYoast

@k3pineapple : Use a formula tool to create the string. "'=" + [data1] + [Tool] + [data2]. Note the single apostrophe before the equals sign. This will tell Excel to interpret the field as a string instead of a formula.

You may need to use the ToString function for data1 and data 2.

All comments

OTrieger

@k3pineapple

I'm not sure if I understand your question, as it is possible to do it in Alteryx but in excel it will be a in a text format.

So what is your question? Are you asking if Alteryx will output =345x345 in excel your will get the calculated value in the cell based on this formula?

k3pineapple

@OTrieger , thx for the help

Want to output "=345x345" into the excel cell, not the calculated value.

How may i convert it to text format in Alteryx? thx thx

dYoast

You may need to use the ToString function for data1 and data 2.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335