Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Keep formula as it is for excel output

saachitalwar
8 - Asteroid

I have to put a formula in a column such that the values aren't present in the wf but once the output is generated, it picks the values from the data. 

 

I have attached the desired output format. The status column needs to have the formula embedded.

8 REPLIES 8
Mathias_Nielsen
9 - Comet

Can the formula not be calculated in Alteryx instead? If you have to do it in Excel, my guess is you need to know the position of the cell in excel to make the formula work. A1, B1 etc.

 

FYI, you only anonymized the data in the first sheet, the others sheets have your data in them still.

Raj
16 - Nebula

@saachitalwar using blob tools use can use your template and then using output tool you and write data into specific range.

hope this helps.

saachitalwar
8 - Asteroid

yes, that can be done. I have set the formula tool with recordID - 

 

'=IF(B'+[RecordID]+'=0,"Not Held",IF(E'+[RecordID]+'=0,"Not in Benchmark",""))'

 

the problem with this is, excel output has this formula as it is. When you press enter then it gives the actual values

Raj
16 - Nebula

@saachitalwar 
you can add the formula as well
find the workflow attached for reference
you can update the formula

mark done if solved
please let me know if further help required.

saachitalwar
8 - Asteroid

I used the given formula but still the formula is printing as it is

 

when I press F2 + Enter then it takes the value it's supposed to

jdminton
12 - Quasar

@saachitalwar that is probably due to Excel. If the field is defaulting to "Text" format before you add it to Excel, it will not be a formula. Are you trying to paste from Alteryx to Excel or are you using output data tool as Raj indicated? If you are pasting, the existing Excel format takes over. You can format the field as "General" and then paste or you can Output from Alteryx directly to an Excel file. Let us know how it goes!

saachitalwar
8 - Asteroid

I'm getting the output through render tool as this column would be part of a larger table. Do you think the render tool is causing the issue?

jdminton
12 - Quasar

Yes, I don't believe you can output formulas with the render tool. I think because it pulls the formatting from the Alteryx format. This would mean that Excel defines what Alteryx says is text as text formatted. I don't use the table and render tool often as most of my projects are from a data perspective without much need for reporting tools, but I'm seeing articles using blob tools to get around this. 

https://community.alteryx.com/t5/Engine-Works/Excel-Templates-with-Blob-Tools-and-Control-Containers...

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

 

Labels
Top Solution Authors