Start Free Trial

Alteryx Designer Desktop Discussions

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

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