1 Reply Latest reply: Feb 20, 2017 3:50 AM by Darren Ball RSS

    Pull data from MongoDB

    sagar kharpude

      Hi All,

       

      What is right way to load data from MongoDB?

       

      Currently I have Added a Web File with URL from QVSource 'mongo'.

      Written Load script in Qlik Sense from above created web file as this

      1. LOAD
        1. linking_id as Name,
        2. "timestamp" as "Time",
        3. value as Value
      2. FROM [lib://mongo]
      3. (qvx);

       

      But I am getting the data in below format

       

      [{ "Address" : "00:0A:F7:2D:2C:D1", "IpAddresses" : [{ "Address" : "10.180.74.14", "IPSubnet" : "255.255.252.0" }, { "Address" : "fe80::b57d:f0e7:3891:bd21", "IPSubnet" : "64" }] }]

       

      { "InventorySiteId" : "0c396f1f-2139-4590-8c75-4a47ae8bb407", "SiteComputerId" : "0a604b58-1994-4958-b40f-adc8232b74a5" }

       

      [{ "_t" : "DirectX", "Version" : "4.9.0.904" }, { "_t" : "Antivirus", "Name" : "AVG CloudCare AntiVirus", "State" : "262160" }]

       

      Thanks in Advance.