We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
fireworks

Input a summary excel sheet that contains hyperlink to several sheets in the same file

JunyuZ
5 - Atom

Hi guys. I'm trying to input an excel sheet just like the screenshot below to Alteryx. However, I have no idea how I can keep the hyperlinks in the sheet as hyperlinks in Alteryx and make an output with the hyperlinks work. 

JunyuZ_0-1667972406116.png

Alteryx would automatically change the Type of this field to V_String.

As those hyperlinks connect different sheets inside the file, I cannot just simply copy the links to a new column and use the Report tool to add them back. Can anyone help me to keep those hyperlinks? Thanks in advance!!

 

1 REPLY 1
patrick_mcauliffe
14 - Magnetar
14 - Magnetar

Does the output need to be a raw Excel sheet, or could it be a formatted report within an Excel file?
You can embed links to other Excel sheets within the Report Output tool.

See Ben's post here:
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-convert-field-value-to-hyperlink...

 

Or, if you need a non-formatted plain Excel sheet, there is a way (although not quick) to do it by editing the raw Excel file properties.

Labels
Top Solution Authors