Hyperlink Excel Formula

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!

Workflow

Reporting

Output

Tips and Tricks

Help

Accepted answers

Loic

@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:

Active URL in Field.yxzp

All comments

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.

Hyperlink.yxmd

Loic

@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:

Active URL in Field.yxzp

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.

Before CrossTab.png

After CrossTab.png

WF.png

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...

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

HyperLink shown as text.JPG

HyperLink after enable it.JPG

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703