community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Output to Excel - Field Containing URL

Highlighted
Asteroid

Hi,

 

     I want to export a standard Excel sheet but one of the fields contains an hyperlink.  When the user opens up the file, I need the URL to show up as an hyperlink (in blue and underlined).  This only happens if I edit the field in Excel.  Attached is my simple workflow.  Should I be using another tool other than "Output Data"?  I attached a sample workflow.

 

Current and required results

Output to Excel.pngOutput to Excel2.png

 

 

 

 

Regards,

Pascal

Alteryx
Alteryx

Pasccout,

 

I think there might be two possible ways to achieve what you are looking for, both of which require use of the Reporting tools.  Specifically the Report Text tool, which gives you the ability turn the URL sting in your data into a link, or you can just use this tool to make the fields in your URL column Blue and Underlined.  The attached workflow demonstrates both options.  Both options require you to use the Report Text tool, the Table tool, and the Render tool.

 

If you want the results of the attached workflow to generate an Excel file in your folders, change the configuration in the "Output Mode" on the Render tool (pictured below).  Right now it is set to Render a temp Excel file, but you can change it to render physical file on your desktop.

 

Render Tool.jpg

Asteroid

Thank you

Labels