Number of rows in Thingworx Analytics has a value of zero

[Nuttapol]

When i generate a new dataset, the number of rows tab has a value of zero

  These are CSV File and json code

  

[

{

        "dataType": "DOUBLE",

        "description": "C",

        "displayOnly": false,

        "fieldName": "C",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "D",

        "displayOnly": false,

        "fieldName": "D",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "E",

        "displayOnly": false,

        "fieldName": "E",

        "lever": false,

        "objective": false

},

{

        "dataType": "DOUBLE",

        "description": "F",

        "displayOnly": false,

        "fieldName": "F",

        "lever": false,

        "objective": false

}

]

[jgreiner]

Hi Nuttapol,

I have 2 questions to help me troubleshoot this issue:

1. what version of ThingWorx Analytics Builder are you using?
2. Are there any errors in the Application Log file in you ThingWorx Composer?

Thanks and Please Advise,

John

[Nuttapol]

John GreinerThank you for answer

1. I use trial version

2. It don't have update log file when i  upload dataset

[cmorfin · Accepted solution]

Hi Nuttapol

The issue (or at least one that woudl lead to 0 rows showing) is that you have no field defined as goal in the json file.

You need to have at least one field defined as goal ("objective": true ), so that the engine knows what to predict.

Without a goal, the dataset is indeed loaded as 0 rows.

Hope this helps

Kind regards

Christophe

[Nuttapol]

Thank you so much Christophe Morfin

[cmorfin]

Hi Nuttapol

I am happy it worked for you.

If you do not mind, it would be useful if you could mark the reply as correct answer so that others facing the same issue will be able to easily find the solution.

Thank you

Kind rgeards

Christophe