Any url in a table chart is automatically converted to a clickable hyperlink. If you’d like, you may set a title for those hyperlinks using Markdown syntax, in the format ** [ title ]( url ) **. We’ll get this format by concatenating the string values with our column names in a Pipeline formula.
In our example, we have two columns in our dataset: Title and Url. We’ll add an Add Column pipeline step and choose Custom formula. Our custom formula is as follows:
|The double pipes (||) allow us to concatenate strings together with our column names to get Markdown formatting.|
If you’d like to use a static string instead of a column value for your link titles, simply replace “Title” with ‘String Value’. Note the single quotes for strings.
In the following example, the Orders table in our PostgreSQL database has two columns: order_id and order_url. To set the order_id as the title for the order_url, we’ll use the following in SQL Mode:
select ‘[’ || orders.order_id || ‘](‘ || orders.order_url || ‘)’ as link from public.orders
If you’re using another type of database, check its documentation for string concatenation syntax.