Excel Formula Output

Hi,

I am wondering if it is possible to output formulas in excel rather than just numbers. In other words, if a column in Alteryx is the product of two columns - can I output into excel so that when I click into the cell I can see the formula?

Example:

Column A = 100

Column B = 2

If I create Column C called "Market Value" with the formula tool and set it equal to [A] x [B] I will get 200. When I output into excel, all I will see is 200 in column C. Is there any way I can output so that when I click into the cell I will see =[A] x [B]?

Thanks!

Lion24

Output

Accepted answers

All comments

AmeliaG

Hi @Lion24,

Thanks for your question! You can use the 'Field Info' tool to pull the formula information for a column. See screenshot below 'Source' field to see the formula information for the column.

geraldo

Here's a suggestion on how to assemble the formula without assigning the values. In excel to work ranges must be named

attached workflow

[]

excellformula.yxmd

Lion24

Hi Amelia,

Thanks for the response. I see how I can use that tool to show the formula. However, I still want to output the actual result of the formula in the column but when I click into the cell I can see the formula in the excel formula bar. Is this possible?

ebwest

I'm not sure if this has been answered already, but you can use the Record ID tool and a formula to write the formula out to Excel and have it populate the formula result and be able to see the formula when you click in the cell.

You bring in your data, add a "Record ID" tool to number the rows, and then add a "Formula" tool to add the string version of the formula. The example below would do A2-B2 on row 2, A3-B3 on row 3, etc...

"=A"+tostring([RecordID]+1)+"-B"+tostring([RecordID]+1)

When you export to Excel and open the file, it shows "=A2-B2", etc... in the field when you click on the cell, and it shows the numeric result when you're not clicked in the cell.

Hope this helps.

JarekSkudrzyk

@ebwest this is a great solution - simple and effective! thank you for sharing it!

Pilsner

@ebwest just come across your post now, and it's worked the first time. This is a great trick for Excel outputs. Thanks for sharing!

Quick Links

This months top contributors

SophiaF 432

AkimasaKajitani 390

mceleavey 388

mbarone 337

michael_weaver 335