Hyperlink

[Thiviya]

HI, Attached excel file has a hyperlink in column " journal link" - column C  and "voucher link"  - column Z

How do I keep that link all the way though out in the Alteryx. Can you please show me what tool can do this ? Thanks

Regards

Thiviya

[binuacs]

@Thiviya One way of doing this. The ColumnC and ColumnZ fields are having the extracted hyper links, you can move this using the select tool

[Thiviya]

Thanks for your reply. I am bit confused with the workflow. Why do we have three same input data but has different information? Do we need all that to get the hyperlink working ?

[binuacs]

@Thiviya yes, in the backend of excel all data and formulas are saved in the xml format, in order to extract these data you need to read the xml part of the excel file like above

[Thiviya]

Thanks . I am still not sure how do I apply. I need something bit more clearer...

[lutherblanks]

---

@Thiviya wrote:

HI, Attached excel file has a hyperlink in column " journal link" - column C  and "voucher link"  - column Z

How do I keep that link all the way though out in the Alteryx for my web about lightsaber toy management. Can you please show me what tool can do this ? Thanks

Regards

Thiviya

---

Got same issue but after seeing the answer i got more confuse , now what i do .

[binuacs]

@Thiviya I don't think you can bring the hyperlink and the data the same way to Alteryx, I mean in your example you are looking for Column C to import to Alteryx the same way it is in Excel. What you can do is extract the hyperlink from Column C and bring it into a different column, but not very similar to what you see the same data in Excel

[Thiviya]

Hi, 

Yes now I am aware I cannot bring the same link I had in the excel version. However, to bring the link into different column with the expanded URL for each transaction line how do I do it? I am not that expert to read the back end of xml etc.. so I need bit more guidance on how to bring the URL into another column?

Thanks

[binuacs]

@Thiviya thats what the workflow I provided you does, check the fields named ColumnC and ColumnZ in the given output