2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

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

Input Excel file containing Hyperlinks

Markus79
5 - Atom

Hello,

 

I'm having the following problem when trying to load an excel file that contains hyperlink and a display text for the hyperlink. The problem is that Alteryx only show the Display text and does not load the hyperlink.

 

Does any one have any idea on how to solve this problem i need the Hyperlink. Please see the attached sample excel file

 

Regards

Markus

6 REPLIES 6
KaneG
Alteryx
Alteryx

Hi @Markus79,

 

I'm curious to see if anyone comes up with anything else, as the problem comes in that Excel doesn't store the hyperlinks as values for the field, but rather an external relationship in a relationship xml inside the XLSX package. So, that being said, when bringing in Excel files, we bring in the values, not look for external relationships.

 

I have a manual way of getting these out as a reference to the cell, however it is not a guarantee, as I don't know everything about how Excel may store theses relationships, and whether having other relationships in the file will effect retrieving these ones. It works on your example. So, it really depends on whether you are just trying to get the hyperlinks once or twice, or whether you will have to do this on a variety of sheets regularly.

 

In the attached, I have read the Excel file twice as a zip file, bringing in a different XML from the package each time as Sheet1.xml.rels.xml contains the hyperlinks and links them to a relationship ID, whereas Sheet1.xml contains the cell ID and links that to the Relationship ID. 

 

Take a look at the attached package to get a better idea of what I mean. If you just need to get the links on an ad-hoc basis, then this might be the way... I've shown a quick example of using CharToInt in order to get the column number as well (might mean more than B5 for instance)

 

Note: This is taking advantage of the way an Excel package is structured, an XLSX file is essentially just a bunch of XML files zipped up. Try unzipping a XLSX file to see what I mean. That's what the X on the end stands for...

polstad
5 - Atom

I've got a similar instance where I am exporting a SharePoint list to xlsx. The SP list contains hyperlinks to sub-sites which are displayed as a name vs the full path. I am attempting to merge that export with some additional data and want the hyperlinks to remain active.  I took a look at your workflow and I see how you are getting to the data but I am a little lost as to how I can accomplish this.

KaneG
Alteryx
Alteryx

Hi @polstad,

 

I don't have a dynamic way of achieving it. Not knowing just what your files look like, not sure what I could advise differently to above. The method I've mentioned above is really an ad-hoc kind of work-around and it may not necessarily always apply.

polstad
5 - Atom

Sounds good, I just wanted to pose the question given it had been a few months.

 

Thank you for your reply!

Patrick

szkz
6 - Meteoroid

I have similar case where attached is the input excel file where column document name and document number is having hyperlink attached to it.  Need help in related to how to retain hyperlinks in those two column in the output excel file

KaneG
Alteryx
Alteryx

As that was saved as a CSV file, there is no data left in it. You should be able to modify my original workflow though in order to pull the hyperlinks

Labels