If you need to stitch two strings or pieces of text together, you can use Calculated Columns to concatenate them. 

Click on the Calculated Columns button. 

Then enter a field name separated by the double pipe || and then the field name you want to add together. You can also concatenate text by wrapping the text in 'single quotes'. 

{field name} || {field name} || 'text' 

You can also concatenate strings using SQLite like this:

SELECT NAME || SURNAME AS USER_NAME FROM USERS

Which would result in 'NAMESURNAME'

If you want characters in between the two variables, make sure to include a space. Like this: 

SELECT NAME || ' ' || SURNAME AS USER_NAME FROM USERS

Which would result in 'NAME SURNAME'

If you need help, please chat in, and we would love to help you. 

Did this answer your question?