- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-04-2022 12:33 PM
Similar discussion is being carried forward on a different thread:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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?
Diane Miller
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-10-2022 02:41 AM
@darshthakkar , do you have RPE - Remote Python Executor enabled on your snaplex?