Hyperlink

[wkeicher]

Trying to add a column in Query editor as a hyperlink that considers the value in another column. The Url is static with the exception of the field I want to add. The purpose is to generate this column and also apply a short URL to a visual Table.

https://servicesportal.domain.com/Ticket_InsertEdit.aspx?Id=[TicketNo]

[Anonymous]

Link = CONCATE("https://servicesportal.domain.com/Ticket_InsertEdit.aspx?Id=", "[TicketNo]")

After running the formula make sure to change the column data category to web URL.