This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
FAQ
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Can we hyperlink inside a mapper snap?

Go to solution
darshthakkar
Valued Contributor

‎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:

image

image

Thanking in advance for your help 🙂

Regards,
DT

0 Kudos
1 ACCEPTED SOLUTION

Go to solution
darshthakkar
Valued Contributor

‎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.

CC: @dmiller @robin
#multiplesolutions #creditsharing

View solution in original post

19 REPLIES 19

Go to solution
darshthakkar
Valued Contributor
In response to Lydia

‎04-29-2022 02:40 PM

@Lydia: The string works now and the mapper doesn’t throw any error however the excel generated keeps it as a string, doesn’t evaluate as a formula, screenshot below:

image

Any suggestions?

0 Kudos

Go to solution
Lydia
New Contributor II
In response to darshthakkar

‎05-02-2022 08:34 AM

If you clic in the F2 cell and then press enter does the formula gets calculated then ?
I’d think this is because the output printed is “text” so it shows the text until you click it and it understand it’s a formula instead. I’m not sure how you could fix this, this has probably to do with excel settings too…

0 Kudos

Go to solution
darshthakkar
Valued Contributor
In response to Lydia

‎05-02-2022 08:44 AM

Yes, clicking enter does the trick in excel and I tried to put an excel parser in the pipeline too (as it has the option of calculating the formulas) but the pipeline gets complicated as at the end as we would need to use a combination of mapper, document to binary, parser, etc.

image

0 Kudos

Go to solution
Lydia
New Contributor II
In response to darshthakkar

‎04-29-2022 01:15 PM

Hum… I’m using a french version of Excel so symbols might be different… But i tried it on my side and it worked

Testing For Excel Link_2022_04_29.slp (6.5 KB)
image

Maybe try using double quotes
"=HYPERLINK(\"https://www.google.com/\",\""+ $ID +"\")"

Testing For Excel Link_2022_04_29.slp

Go to solution
darshthakkar
Valued Contributor

‎05-02-2022 09:09 AM

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

image

The final output in the excel file remains as is:
image

0 Kudos