SQL Add a Column
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
-
Official comment
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 -
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
Please sign in to leave a comment.
Comments
2 comments