Alteryx Designer Desktop Discussions

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

One hyperlink in a huge excel file

insomned
8 - Asteroid

Hello, 

 

I have an Alteryx workflow, which generates an .xlsx file daily. It has many columns but I want one specific column to be shown as a hyperlink in Excel (in fact, the fields in the column are links, I just want the user to be able to click on them directly). 

 

Is it possible to achieve this without Render and Table tools, because when I use them the format of the whole spreadsheet gets distorted.. 

 

Thank you!

2 REPLIES 2
Prometheus
12 - Quasar

@insomned I know you said you don't want to use Reporting tools, but this solution shows how you can. Check it out: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Hyperlink-Excel-Formula/m-p/50...

ed_hayter
12 - Quasar

Only seems possible by altering the users excel configuration:

 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-convert-field-value-to-h...

 

If you can mock up some dummy data we can try and get the reporting tools in a desired format and get the links working for you.

Labels