Keep formula as it is for excel output
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@saachitalwar using blob tools use can use your template and then using output tool you and write data into specific range.
hope this helps.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/
