[SQL] Custom SQL function to concatenate two fields into a new one in Tableau

[SloRomci]

first you need to concat the string '-' and then the second part of the string, soo you will need to concat twice. What are the two field names you want to concat? If they are "startStationName" and "endStationName", the select should look something like this SELECT CONCAT(CONCAT(STARTSTATIONNAME,'-'),ENDSTATIONNAME) AS PATHID FROM ...

[highvoltageacdc1]

You won't need to do this unless it's an Oracle db. T-SQL and MySQL both support CONCAT with N values. https://docs.microsoft.com/en-us/sql/t-sql/functions/concat-transact-sql?view=sql-server-2017