Export to Excel

Reply
Green Belt

Export to Excel

This question is similar to Table Card export in that it is about exporting to Excel.  I am trying to export a dataset / column as a hyperlink.  In Excel, that could be a formula: =HYPERLINK(...  The issue I'm having is that the export ALWAYS seems to prepend an apostrophe onto the formula, just before the equal sign.  

 

Any ideas on how to get around that?  I know that I am not putting it there; my dataflow includes a SQL step that builds the formula:

'=HYPERLINK("https://emc.my.salesforce.com/' || "opp_id" || '", "' || "opp_nm" || '")' AS "Opportunity LINK"

but the single quotes are needed for the concatenation.  The export does it both as Excel export and .CSV export.  Weird.  

Matt 

Matthew O Coblentz
Green Belt

Re: Export to Excel

 

Could you give an example of what the value looks like before you export it?

Announcements
Check out these great solution videos! The new iSolveditWithDomoboard is live, share yours and earn higher rankings in Dojo click here!