sql code for big query node

[nik80]

Hello, I need help in using the DB Query node.
I have a Data List as follows:

My goal is to create a new “NOMINATIVE” field this way:

I tried a first query

SELECT *, CONCAT (DES_SURNAME, ‘’, DES_NAME) NOMINATIVE FROM # table # AS table

But then I can’t update the table by taking the Business Name field if the Name field is null

THANKS

[mlauber71]

I think you need a CASE WHEN statement

SELECT *
, CASE WHEN “BUSINESS NAME” IS NOT NULL OR trim(“BUSINESS NAME”) <> ‘’ THEN “BUSINESS NAME”
ELSE CONCAT (DES_SURNAME, ’ ', DES_NAME) END AS
NOMINATIVE
FROM # table # AS table

You migzt have to play around with the quotation marks. Some Programs do not like variable names with blanks.