TQL Concat 2 columns

Can we get the resultant of 2 columns from a table into 1 column?

 

Example query in SQL:

Select column1+column2 from schema.table;

Select ConCat(column1+column2) from schema.table;
1reply Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Idea T  You have do that using a formula concat(column1, column2) and use it in the search. You cannot do it using SQL. 

    Reply Like
Like Follow
  • 8 mths agoLast active
  • 1Replies
  • 93Views
  • 2 Following