Referencing null in Google BigQuery
Multi tool use
Clash Royale CLAN TAG#URR8PPPReferencing null in Google BigQuery
I'm not sure how to reference the null value I'm seeing below. I believe this null value was generated as a result of a LEFT JOIN but now I want to replace this String and have no way of referencing it
1 Answer
1
to reference this NULL value in mobile_type field you can use
WHERE mobile_type IS NULL
or if this is result of LEFT JOIN - you can modify your respective SELECT - instead of something like SELECT mobile_type - you can use SELECT IFNULL(mobile_type, 'none') (for standard sql)
SELECT mobile_type
SELECT IFNULL(mobile_type, 'none')
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
