Why does my dataset have empty rows in the result preview? Problem with dataset in IoT Analytics.

0

I'm editing my JSON report through the IoT Analytics pipeline by adding attributes but when I look at the dataset and look at the content it shows the values I expect except for some blank lines and that's the thing I don't understand. Why am I getting blank lines with no values? *

Here is the incoming message to the pipeline

{
  "mType": "iqrfSensor_ReadSensorsWithTypes",
  "data": {
    "msgId": "testEmbedSensor",
    "rsp": {
      "nAdr": 1,
      "hwpId": 2,
      "rCode": 0,
      "dpaVal": 85,
      "result": {
        "sensors": [
          {
            "id": "TEMPERATURE",
            "type": 1,
            "name": "Temperature",
            "shortName": "t",
            "value": 27.5,
            "unit": "°C",
            "decimalPlaces": 4
          },
          {
            "id": "TEMPERATURE",
            "type": 1,
            "name": "Temperature",
            "shortName": "t",
            "value": 27,
            "unit": "°C",
            "decimalPlaces": 4
          },
          {
            "id": "BINARYDATA7",
            "type": 129,
            "name": "Binary data7",
            "shortName": "bin7",
            "value": 55,
            "unit": "?",
            "decimalPlaces": 0,
            "breakdown": [
              {
                "id": "BINARYDATA7",
                "type": 129,
                "name": "Light indicator",
                "shortName": "light",
                "unit": "%",
                "decimalPlaces": 1,
                "value": 56.7
              }
            ]
          },
          {
            "id": "BINARYDATA7",
            "type": 129,
            "name": "Binary data7",
            "shortName": "bin7",
            "value": 46,
            "unit": "?",
            "decimalPlaces": 0,
            "breakdown": [
              {
                "id": "BINARYDATA7",
                "type": 129,
                "name": "Potentiometer",
                "shortName": "pot",
                "unit": "%",
                "decimalPlaces": 1,
                "value": 63.8
              }
            ]
          }
        ],
        "sensorIndexes": [
          0,
          1,
          2,
          3
        ]
      }
    },
    "raw": [
      {
        "request": "01.00.5e.01.ff.ff.0f.00.00.00",
        "requestTs": "2023-06-07T14:59:18.076+02:00",
        "confirmation": "01.00.5e.01.ff.ff.ff.58.01.08.01",
        "confirmationTs": "2023-06-07T14:59:18.102+02:00",
        "response": "01.00.5e.81.02.00.00.55.01.b8.01.01.b0.01.81.37.81.2e",
        "responseTs": "2023-06-07T14:59:18.353+02:00"
      }
    ],
    "insId": "iqrfgd2-default",
    "statusStr": "ok",
    "status": 0
  }
}

And here is outcoing message from pipeline activities

{
  "mType": "iqrfSensor_ReadSensorsWithTypes",
  "data": {
    "msgId": "testEmbedSensor",
    "rsp": {
      "nAdr": 1,
      "hwpId": 2,
      "rCode": 0,
      "dpaVal": 85,
      "result": {
        "sensors": [
          {
            "id": "TEMPERATURE",
            "type": 1,
            "name": "Temperature",
            "shortName": "t",
            "value": 27.5,
            "unit": "°C",
            "decimalPlaces": 4
          },
          {
            "id": "TEMPERATURE",
            "type": 1,
            "name": "Temperature",
            "shortName": "t",
            "value": 27,
            "unit": "°C",
            "decimalPlaces": 4
          },
          {
            "id": "BINARYDATA7",
            "type": 129,
            "name": "Binary data7",
            "shortName": "bin7",
            "value": 55,
            "unit": "?",
            "decimalPlaces": 0,
            "breakdown": [
              {
                "id": "BINARYDATA7",
                "type": 129,
                "name": "Light indicator",
                "shortName": "light",
                "unit": "%",
                "decimalPlaces": 1,
                "value": 56.7
              }
            ]
          },
          {
            "id": "BINARYDATA7",
            "type": 129,
            "name": "Binary data7",
            "shortName": "bin7",
            "value": 46,
            "unit": "?",
            "decimalPlaces": 0,
            "breakdown": [
              {
                "id": "BINARYDATA7",
                "type": 129,
                "name": "Potentiometer",
                "shortName": "pot",
                "unit": "%",
                "decimalPlaces": 1,
                "value": 63.8
              }
            ]
          }
        ],
        "sensorIndexes": [
          0,
          1,
          2,
          3
        ]
      }
    },
    "raw": [
      {
        "request": "01.00.5e.01.ff.ff.0f.00.00.00",
        "requestTs": "2023-06-07T14:59:18.076+02:00",
        "confirmation": "01.00.5e.01.ff.ff.ff.58.01.08.01",
        "confirmationTs": "2023-06-07T14:59:18.102+02:00",
        "response": "01.00.5e.81.02.00.00.55.01.b8.01.01.b0.01.81.37.81.2e",
        "responseTs": "2023-06-07T14:59:18.353+02:00"
      }
    ],
    "insId": "iqrfgd2-default",
    "statusStr": "ok",
    "status": 0
  },
  "name1": "Temperature",
  "unit4": "%",
  "name2": "Temperature",
  "unit3": "%",
  "name4": "Potentiometer",
  "unit2": "°C",
  "name3": "Light indicator",
  "value1": 27.5,
  "time": "2023-06-07T14:59:18.353+02:00",
  "value3": 56.7,
  "unit1": "°C",
  "value2": 27,
  "value4": 63.8
}

I use new SQL statement in my dataset then before * old statement: SELECT * FROM 'my/topic' * new statement: SELECT name1,unit1,value1,name2,unit2,value2,name3,unit3,value3,name4,unit4,value4,time,__dt FROM 'my/topic' * Here is Result preview in dataset Enter image description here

MikMar
asked 10 months ago69 views
No Answers

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions