SnapLogic - Integration Nation

darshthakkar · ‎04-29-2022

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

darshthakkar · ‎05-10-2022

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

View solution in original post

darshthakkar · ‎05-04-2022

Similar discussion is being carried forward on a different thread:

Reading files from SL manager?

darshthakkar · ‎05-09-2022

Looping in the SMEs for their suggestions on this one…

CC: @robin @dmiller @Spiro_Taleski @bojanvelevski @siwadon @Supratim @alchemiz

dmiller · ‎05-09-2022

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

Diane Miller

darshthakkar · ‎05-09-2022

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

bojanvelevski · ‎05-10-2022

@darshthakkar , do you have RPE - Remote Python Executor enabled on your snaplex?

SnapLogic - Integration Nation

Can we hyperlink inside a mapper snap?