JSON Array Parsing Tips & Tricks

Follow

Anson Chan

• January 18, 2021 09:35

Hello,

We have a question around Parsing JSON array column where not every cell has an array.

For example:

during the parsing of using JSON_ELEMENTS function on a JSON_ARRAY Column and notice that any rows that is "empty" will be disregarded upon completion of the JSON_ELEMENTS function.

Is there a way to while parse the JSON Array and yet retrain all the other rows in the data set after the operation?

Thanks, Anson

My question is, how do we get to the outcome of whilst 

0

• 

  Alan

  • January 18, 2021 19:59

  Hi Anson,

  You can achieve this goal with an IF statement.  You can do something like this:

  IF(!Sheet#tags == '';'';JSON_ELEMENTS(!Sheet#tags))

  This will first check if there is no value in the tags column.  Then, if no value is found it will just set the record to no value.  Else, use JSON_ELEMENTS.

  You'll also be happy to hear that I've activated you within Zendesk.  I sent you an email directly with further information.

   

  Sincerely,
  Alan

  0

  Comment actions Permalink
• 

  Anson Chan

  • January 25, 2021 13:05

  Hello Alan,

  Much appreciated for yours and Datameer's support.

  thanks,

  Anson

  0

  Comment actions Permalink

Please sign in to leave a comment.