From Can I code To helping in Code!

ShermeenKiran — Mon, 08 Mar 2021 08:05:00 +0000

As of International women day I want to tribute every woman writing code. Every female programmer participating. I want to appreciate every women fighting social , psychological barriers and continue moving :)

Little Story:

I was high school graduate with Biology Major.
Did my graduation at Business School.
Registered Information Technology at University (was actually an accident while applying)
5 years of Experienced Software Engineer have coded in java , React js , Native , Umbraco , Hubspot.

Stepping into career as Programmer was a #Challange. Encountered a lot of questions #womancantcode #womancannotlastincode #choseeasyprofession #womancantdealit

late feedbacks , critical push backs but The light inside was reflecting this all in a rainbow!!

I give Bravo to All woman coding regardless of hurdles , judgments.

You are stars should code , Manage , Lead and Participate :)

HappyWomen'sDay

Answer: Big Query filtering null rows of Custom query creating table

ShermeenKiran — Fri, 06 Dec 2019 07:12:56 +0000

answer re: Big Query filtering null rows of Custom query creating table

Dec 4 '19

Below is for BigQuery Standard SQL

#standardSQL
SELECT * FROM (
  SELECT 
    (SELECT x.value 
      FROM UNNEST(user_properties) x 
      WHERE x.key='restaurantName' 
      AND x.value IS NOT NULL
    ).string_value AS restaurantName ,
    (SELECT x.value 
      FROM UNNEST(user_properties) x 
      WHERE x.key='restaurantId' 
      AND x.value IS NOT NULL
    ).string_value AS restaurantID , 
    (SELECT x.value 
      FROM UNNEST(user_properties) x 
      WHERE

…

Open Full Answer

DEV Community: ShermeenKiran

From Can I code To helping in Code!

HappyWomen'sDay

Answer: Big Query filtering null rows of Custom query creating table

answer re: Big Query filtering null rows of Custom query creating table