Issue with my output file

Question

Hi,

Hope someone can help me with the end part of my report.

Attached please find my  workflow. I put ' Report run date' in a formula to add date into my output name, but basically there is column in my output excel file with that. How can I delete that column from my Excel but still have date as the name of my file?

Many thanks

New Workflow.yxmd

AbhilashR · Accepted Answer

Hi! Just modify your Formula tool by combining Report Run Date and Filename field to something like this

'Performance Dashboard - ' 
+ DateTimeFormat(datetimetoday(),"%Y_%m_%d") 
+ ".xlsx|||GP Perf"

This way you don't have that extra Report Run Date column in your output. Alternatively you could put a Select tool after the formula tool and uncheck Report Run Date column.