4 Replies Latest reply: Jul 18, 2012 11:59 PM by Kadir Okan Piroglu RSS

    Json like data to table?

    Kadir Okan Piroglu

      Hi Everybody,

       

      I need some help. One of the fields I am supposed to refer to is returning, so called Json like data - please see below. I am looking for a way to create columns with corresponding labels and consisting values. I would like to do this with scripting so that I can connect/display fields to rest of the report.

       

      My data comes from a flat table, not from web etc and each row might have different contents and I cannot use Inline. (please see attached)

       

      Any advice or help will be appreciated.

       

      Best,

       

       

      What I have in a single cell is:

      {"F.13-17":722,"F.18-24":544,"M.18-24":469,"M.13-17":414,"F.25-34":126,"M.25-34":116,"M.35-44":91,"F.35-44":86,"F.45-54":41,"M.45-54":35,"M.55+":19,"F.55+":18,"U.18-24":8,"U.35-44":5,"U.UNKNOWN":4,"U.45-54":3,"U.25-34":2}

       

      What I want is a table like:

       

      F.13-17F.18-24M.18-24M.13-17F.25-34M.25-34M.35-44F.35-44F.45-54M.45-54M.55+F.55+U.18-24U.35-44U.UNKNOWNU.45-54U.25-34
      72254446941412611691864135191885432