Hyperlink Excel Formula

[acanonicco001]

Hi

I have an output which contains an url in one column and a title in another one. Is there a way to output a field (as the hyperlink excel formula) that displays only the title but when you click it, it contains the url link? Or something similar?

Thanks for the help!

[JoeS]

Hi @acanonicco001 

I believe the tool to create hyperlinks in Alteryx is the Report Text tool.

This will create the hyperlink (see attached) but I am not sure that it will work for you full scenario.

Unless it is just that that you want in your Excel sheet.

[Loic · Accepted solution]

@acanonicco001 Here is how to do it. It will show the title as an active URL and when clicking on it in Excel it will actually go to the URL directly.

Use reporting tools (default excel output doesn't allow formatting): "Text" tool to create a new text field with this syntax: <Link [Title:A]|[URL:A]>

Basic Table and then Render to create an excel file that takes into account formatting.

Output:

[acanonicco001]

This is exactly what I needed. Thank you!

[Jason_]

This method is great, and it works well; however, I have a situation that seems like a bug. Has anyone else encountered this:

After creating the link, I have a CrossTab

My links come out fine if I export before the cross tab, but after the cross tab they are shortened.

The Link is what is being aggregated in the cross tab (method=First).

If anyone has encountered this and can help, I would appreciate the input.

Thanks.

[bcastro1991]

If you don't want to use Reporting Tools, you could also create the hyperlink by creating the Excel Hyperlink function within a Formula tool. 

Excel Hyperlink Syntax: HYPERLINK(link_location, [friendly_name])

In Formula tool:

Create URL - if you are dynamically creating links (Maybe linking to different records in an internal application)

Create Hyperlink - '=hyperlink("' +[URL]+ '","' + [record id/ specific name in data set]+'")" '

Bold denotes "String Text"

In the final output, you would render that newly created "Hyperlink" column, and that would write to your excel output

[Hanno]

I tried this formula in one of my workflows but result is a cell with truncated characters and the output excle file creates an error message during opening...
Any idea how to solve this...

[TeresaZhang7517]

Hi,

You may need check hyperlink of formula, it should be '=hyperlink("www.url","friendly name of hyperlink")'. But in above reply it is '=hyperlink("www.url","friendly name of hyperlink)"'. I think it is reason why you got opening error.

[U505205]

Hello,

I used the HyperLink to create the links. But in the output excel file, the link was shown as text file.  Clicking on the text field won't take me to the right place.   I have to click on the cell, add a blank space, then click enter key to make it become active link.   

My excel works fine if I manually create a hyperlink. Does anyone encounter such issue and how to solve it?

Thank you

Lisha

[U505205]

I was able to figure it out using LInk.  Here is my code and it works well. 

<Link [Back to Summary:A]|#'Summary'!A1>

Thank you

Lisha