none
Transforming column content to a hyperlink in Power Query RRS feed

  • Question

  • I've been using a formula in Excel to give me redirect links like this:

    =HYPERLINK(CONCATENATE("http://myurl.com/redirect/","/",A2),Fancy Title)

    Is there a way to replicate this in Power Query?

    Thanks,

    Jes


    JesB Office Store

    Friday, January 17, 2014 11:39 PM

Answers

  • Not directly, no. Once you've run the query, you can manually add a column to the result table in the worksheet of course. But at least for now, the added column would be lost when the data is refreshed.

    • Proposed as answer by Curt Hagenlocher Monday, January 20, 2014 1:51 PM
    • Marked as answer by JesB Monday, January 20, 2014 4:47 PM
    Saturday, January 18, 2014 4:37 AM

All replies

  • Not directly, no. Once you've run the query, you can manually add a column to the result table in the worksheet of course. But at least for now, the added column would be lost when the data is refreshed.

    • Proposed as answer by Curt Hagenlocher Monday, January 20, 2014 1:51 PM
    • Marked as answer by JesB Monday, January 20, 2014 4:47 PM
    Saturday, January 18, 2014 4:37 AM
  • Just add a column to the generated spreadsheet with the formula you provided. It will persist on data refresh. I think this is an Excel 2016 feature.
    • Proposed as answer by CarlinScott Monday, March 2, 2020 8:00 PM
    Monday, March 2, 2020 8:00 PM