โ04-29-2022 11:28 AM
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
Solved! Go to Solution.
โ05-10-2022 06:36 AM
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.
โ05-04-2022 12:33 PM
Similar discussion is being carried forward on a different thread:
โ05-09-2022 06:28 AM
Looping in the SMEs for their suggestions on this oneโฆ
CC: @robin @dmiller @Spiro_Taleski @bojanvelevski @siwadon @Supratim @alchemiz
โ05-09-2022 06:49 AM
Any chance you have auto-hyperlink disabled?
In Excel, under Tool > Autocorrect options, is Replace internet and network paths with hyperlinks selected?
โ05-09-2022 07:01 AM
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
โ05-10-2022 02:41 AM
@darshthakkar , do you have RPE - Remote Python Executor enabled on your snaplex?