0 Replies Latest reply: Jan 19, 2018 10:46 AM by da da RSS

    accessing a sub field with MongoDB

    da da

      Hi everyone !

       

      I have connected QLIK to MongoDB using an ODBC driver

      I can get/view/manage the values, it works quite fine.

       

      My issue is that one of the field (Info) is containing sub-fields such as ID, Event, Value

       

      {

          "_id" : ObjectId("58dbb7234a4ccc246c000006"),

          "message" : "{\"i\":\"40:6E:60\",\"e\":\"654654\",\"s\":\"TF\"}",

          "@timestamp" : "\"2017-03-29T13:31:15.045Z\"",

          "host" : "IPADDRESS",

          "insertTime" : "1490794275",

          "info" : {

              "id" : "MACADDRESS",

              "event" : "654654",

              "value" : "machannel"

          }

      }

      I want to get stats on values, for example.

      But in QLIK, only INFO is available

      is there a solution ? Hope I am clear enough to get solution

      thanks

      david