Beast mode CONCAT() for creating a dynamic link in a table

PK
PK Member
in Magic ETL

I have a field in my dataset which I want to use to create a new field which is a URL in the below format - 

 

<a href="www.example.com/[`DatasetField`]" target="_blank">www.example.com/[`DatasetField`]</a>

 

Where `DatasetField` is a column in my dataset. 

 

I am doing CONCAT like on the lines I have mentioned but it does not escape quotes - 

 

CONCAT('<a href=','\"',"www.example.com/",`DatasetField`, "" target="_blank">https://www.example.com/",`DatasetField</a>)

 

I know I am missing something and not doing it right. Any help with this would be really appreciated.

 

Thanks.

 

Comments

  • guitarhero23
    guitarhero23 Contributor

    Here is one I use for Salesforce where Id is a domo column

     

    CONCAT('<a href= https://example.my.salesforce.com/',`Id`,' target = new> View in Salesforce </a>')

     

     

    Try this and if that works then attempt to add the datasetfield to the visible text for the URL

    CONCAT('<a href= https://example.com/',`DatasetField`,' target = new> View this data</a>')

     

    Is their a reason for the extra ','\"'," before the www.example?


    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**

Categories