how do i make a URL field clickable?

To make your field containing a valid URL, clickable from Knowi, simply wrap the field in CONCAT function with an HTML href tag mapping to the URL field.

VIDEO WALKTHROUGH:

• https://www.loom.com/share/9220c16ba6da48c185056ecea996fb53

SYNTAX EXAMPLE:

select concat("<a href=",url," target=_blank",">", url , "</a>") as url