Extracting JSON to report on it

Comments

2 comments

  • Avatar
    Assaf Fraindlich (Edited )

    Hi Christopher,

    You can use the strparts() function. It will regard the json field as an array. 

    Syntax : strparts(fieldName,delimiter, index)

    • delimiter - can be a comma, semicolon, \n etc
    • index - which element you wish to extract from the array.

    Example:

    strparts('aa,bb,cc', ',', 2) will result in 'bb'

    1
    Comment actions Permalink
  • Avatar
    Iris Maessen

    Is there also a way to extract various fields from an array like this to separate rows within Sisense? Or does that have to be done in the database?

    0
    Comment actions Permalink

Please sign in to leave a comment.