SQL Add a Column

Follow

Bayani Flores

• February 01, 2020 08:38

I am trying to Concat two strings in the same table. For example, I have a table with column A and column B. I want to create a table with column A, column B and column C(A and B concatenated). 

 

Thanks

0

• Official comment

  

  Scott Bowen

  • February 03, 2020 17:07

  Great question Bayani Flores! You can combine two strings with SQL, but we've made it easier with the Calculated Columns transform. Basically, you can specify the fields you want to concatenate, separated by a double pipe:

  ||

  You can read more in the Calculated Columns help article.

  Comment actions Permalink
• 

  Bayani Flores

  • February 03, 2020 17:10

  Thank you for the quick response. I was able to find that field. It led me to another question that I posted. 

   

  https://help.grow.com/hc/en-us/community/posts/360038576174-Countif-two-columns-are-equal

   

  Thank you.

  Bayani

  0

  Comment actions Permalink

Please sign in to leave a comment.