Link PDF File to a column value

daraghwalker

Hi, I would like to include a column in my excel sheet that contains a hyperlink which directs the user to a local PDF file.

Is there a way to do this in Alteryx? I know the Report Text tool allows you to link to a web-page URL but is this possible for a file?

Thanks

hanykowska

Hi @daraghwalker 

I looked into what you described and I think I managed to solve it!

The way I approached it is to have a full filepath and the name of the file or anything you want to show as the text. Then in the pop up window for hyperlink, you can choose them from available fields:

The key, is to then make a table which is something you will probably need to do anyway to output to an excel file, and make sure to include that text object in there

Then you can use a render tool to save it to a specific or temporary excel file

I will share my workflow, but you will need to update the directory tool to point something on your local machine - otherwise it will be looking for a filepath that I have!

Hope this helps, I also learnt something new, so thanks for asking the question!

local hyperlink.yxmd