Excel convert field value to hyperlink in output

Manojkumar

Hi Team,

Someone please help me with the following.

I have a flow, in which I get an excel file as output, one of the column has the path, but as string.

Is there way to make it hyperlink when creating excel itself?

File path

\\manoj90101\proro\oirriit\

I want it to be an hyperlink when I open excel, not as string.

Please help

Thanks In advance

Topic of Interest

Accepted answers

BenMoss

It is possible to do this directly in Alteryx by using the reporting tools.

The 'Text' tool in the reporting suite allows you to create a hyperlink, we can then bring this together using the table tool (and apply any formatting you want), and then use the 'render' tool to output this as an .xlsx output.

I've attached a working example for you.

It's not possible to do this with the standard output tool, unless you get your users to mess around with their excel configuration as the user above says.

Ben

Example.yxmd

All comments

mmbora

The user of the excel has to enable DDE , by which excel will auto enable any string or text that is present in the workbook as a hyper link. User can hold Ctrl + Click to navigate to the location. This may however not work withany Intranet , FTP location within your internal network.

The link for Microsoft's forum is below :

https://support.microsoft.com/en-us/help/930479/dde-links-are-not-automatically-updated-in-excel-2007

BenMoss

It is possible to do this directly in Alteryx by using the reporting tools.

I've attached a working example for you.

It's not possible to do this with the standard output tool, unless you get your users to mess around with their excel configuration as the user above says.

Ben

Example.yxmd

mmbora

Thanks a lot

Manojkumar

Thanks a lot, Ben. It worked without any issue

TomasGM

I can make hyperlinks to common files but when i try to do this with sheets i get this error

Example.yxmd

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235