The PTC Community email address has changed to email@example.com. Learn more.
The following is valid for ThingWorx Analytics (TWA) 52.0.2 till 8.0
For release 8.3.0 and above see How to score new data in ThingWorx Analytics 8.3.x ?
2. Configure dataset
3. Upload data
4. Optimize the dataset
5. Create filters
6. Train the model
7. Score the training data
8. Upload new data
9. Scoring new data
Hi Christophe Morfin,
This is a very good tutorial indeed for beginners as compared to the one explained in the guide https://developer.thingworx.com/resources/guides/thingworx-analytics-quickstart
I followed all step mentioned above, but when I executed the step no 9 i.e. Scoring new data with filter ScoringNewData, I am getting the below error.
com.coldlight.ai.pmml.InvalidDataException: Unexpected value(s) found in Record with identifier: . Feature [record_purpose] had value of [scoringnew]
I have used serial to uniquely identify rows,  is the row number 71.
I think I know why you are getting this and you are bringing a good point, that seems to be missing in the blog.
The definition of the record_purpose field (or whatever name you gave it) needs to be defined with displayOnly set to true so that the algorithm knows to not take this field into account in the analysis.Indeed for string feature, ThingWorx Analytics needs to have seen all possible values during training otherwise it will report an error "Unexpected value(s) found ..."
In your case if the record_purpose field is not set with displayOnly to true, you will need to create a new dataset with this change in the metadata json file.
The difinition woudl look something like this:
"description": "record purpose",
Hope this helps
The above solution had resolved the issue. However, as a beginner I am finding very difficulty to know the result as explained in step 9. What are these variables PREDICTED GOAL 'CONDITION' SCORE, PREDICTED GOAL 'CONDITION' MIN, PREDICTED GOAL 'CONDITION' MAX. What does they say. Can you please also share with us training and testing files. It will be really helpful for beginner to know all these parameter.
The PREDICTED GOAL 'CONDITION' SCORE is probable the one you want to look at if you want a single value
PREDICTED GOAL 'CONDITION' MIN, PREDICTED GOAL 'CONDITION' MAX represent the range into which the predicted value can fall (remember this is using machine learning ie statistics ). Article Viewer | PTC might help here.
Also the Getting started article should be useful for you to find references: https://www.ptc.com/en/support/article?n=CS248832
Hello Christophe Morfin,
I wanted to know currently what are the machine learning algorithm supported by Thingworx Analytics.
You can find the answer at https://www.ptc.com/en/support/article?n=CS254667
How the pre processing of data is done in thingworx analytics. Like missing value treatment and outlier treatment for paramteric model and tunning and pruning for non paramteric model?
Does Optimize API of thingworx Analytics does the job for me?
The following links should answer some of your questions:
If you still have questions, I would suggest you open a case to Technical Support
Thanks for sharing this with me. Essentially the data has to be prepared before feeding the data into thingworx analytics.