27 Feb 19 · DataFreak · #Bigquery ·   Bookmark   ×

Google Bigquery : Concatenate values from two Columns

Problem 🔍

When trying to concatenate values from two columns in Bigquery, It throws the below error message:

Select  Column1 + '.' + Column2;
Error: No matching signature for operator + for argument types: STRING, STRING. 
Supported signatures: INT64 + INT64; FLOAT64 + FLOAT64; NUMERIC + NUMERIC at [3]

Solution 💡

To Concatenate two strings in Bigquery use the CONCAT function:

CONCAT(Column1,'.',Column2)

Make sure all the columns or expression used within the CONCAT function are of STRING Datatype

DataFreak

posted on 27 Feb 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds