In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors