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!!
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.
User | Count |
---|---|
52 | |
27 | |
26 | |
24 | |
21 |