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

JunyuZ

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. 

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

Hyperlink.xlsx

patrick_mcauliffe

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-in-output/m-p/359859?advanced=false&collapse_discussion=true&q=excel%20hyperlink&search_type=thread

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.