JSON Array Parsing Tips & Tricks

Comments

2 comments

  • Alan Mark

    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

    Hello Alan,

    Much appreciated for yours and Datameer's support.

    thanks,

    Anson

    0
    Comment actions Permalink

Please sign in to leave a comment.