Forum Discussion

darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Solved

Can we hyperlink inside a mapper snap?

Hi Team,

I was tryin to use native JS function link in order to hyperlink inside a mapper. I found that it doesn’t work, does anyone know a similar functionality or a workaround?

Basically, I was trying to hyperlink an existing column “ID” and wanted to output this in an excel file. Snaps below for reference:

Thanking in advance for your help 🙂

Regards,
DT

pipeline
transform
  • darshthakkar's avatar
    darshthakkar
    4 years ago

    Thank you @Lydia and @bojanvelevski for your help on this one. As I can only mark a single comment as a solution, I wouldn’t do justice to one of you but without both of you, this thread wouldn’t have been concluded.

    Thank you @Lydia for providing the formula for hyperlink "=HYPERLINK(\"https://www.google.com\",\""+$ID+"\")" and letting me know that a manual intervention in excel would be needed to just go over that cell and click “Enter” for the formula to work.

    Thank you @bojanvelevski for sharing the workaround of using a CSV Formatter instead of an Excel Formatter, that solution really helped although it does have a manual intervention but lesser than the one stated above (by going into each cells and activating the formulas)

    I’m marking this as a solution intentionally so that I can give credits to both of you and anyone referring to this thread can get best of both the worlds in a single comment.

    Thank you!

    Signing off from this thread as workaround will do the trick for now.

    Best Regards,
    DT

    P.S. Doesn’t mean that I don’t appreciate your efforts and wanted to offend either of you.

    CC: @dmiller @robin
    #multiplesolutions #creditsharing

19 Replies

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago

    Thank you @Lydia and @bojanvelevski for your help on this one. As I can only mark a single comment as a solution, I wouldn’t do justice to one of you but without both of you, this thread wouldn’t have been concluded.

    Thank you @Lydia for providing the formula for hyperlink "=HYPERLINK(\"https://www.google.com\",\""+$ID+"\")" and letting me know that a manual intervention in excel would be needed to just go over that cell and click “Enter” for the formula to work.

    Thank you @bojanvelevski for sharing the workaround of using a CSV Formatter instead of an Excel Formatter, that solution really helped although it does have a manual intervention but lesser than the one stated above (by going into each cells and activating the formulas)

    I’m marking this as a solution intentionally so that I can give credits to both of you and anyone referring to this thread can get best of both the worlds in a single comment.

    Thank you!

    Signing off from this thread as workaround will do the trick for now.

    Best Regards,
    DT

    P.S. Doesn’t mean that I don’t appreciate your efforts and wanted to offend either of you.

    CC: @dmiller @robin
    #multiplesolutions #creditsharing

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      @Lydia: I’m testing the string you’ve provided and haven’t found any luck yet.
      Have you tried the same string on your end?

      I also tried to tweak it as I was getting errors but haven’t been able to achieve the results.

  • bojanvelevski's avatar
    bojanvelevski
    Valued Contributor
    4 years ago

    @darshthakkar,

    I also found a “workaround” but I’m not sure if that will work for you because minimal manual action is required.

    If you use CSV Formatter, instead of Excel, but still use Microsoft Excel to open the file, the hyperlink formula will be evaluated and you can save the file as .xlsx document.

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      Thanks @bojanvelevski, I will try this…

      • darshthakkar's avatar
        darshthakkar
        Valued Contributor
        4 years ago

        @bojanvelevski: This is amazing, it works!

        I tried reading the same CSV file (shown in the snap above) and convert it in snapLogic but the hyperlink doesn’t work there, I believe the workaround should do for now, thanks for testing this @bojanvelevski

  • darshthakkar's avatar
    darshthakkar
    Valued Contributor
    4 years ago

    I tried using the below pipeline so that formulas get calculated but didn’t find any luck:

    The final output in the excel file remains as is:

  • dmiller's avatar
    dmiller
    Former Employee
    4 years ago

    Any chance you have auto-hyperlink disabled?
    In Excel, under Tool > Autocorrect options, is Replace internet and network paths with hyperlinks selected?

    • darshthakkar's avatar
      darshthakkar
      Valued Contributor
      4 years ago

      Thank you @dmiller for your quick response. I do have it selected as default. Screenshot below for your reference:

      For my version of excel, it was under

      Excel > File > Options > Proofing > AutoCorrect options > AutoFormat As You Type > Replace as you type: Internet and network paths with hyperlinks