ThingSpeak


Warning: Non-numeric data was found. This could mean that you are attempting to retrieve data from a channel or field that has non-numeric points. Set 'OutputFormat' property to 'table' or 'timetable' to read non-numeric data.

Saara Väänänen on 21 Mar 2021 (Edited on 21 Mar 2021)
Latest activity Reply by Christopher Stapels on 22 Mar 2021

Hi,

I have an urgent problem. I am reading data from a channel to my channel and visualizing it.

I am reading data from fields 5 and 6 from daterange (2 hours). I manage to get data from channel (below) but I get the message "Warning: Non-numeric data was found. This could mean that you are attempting to retrieve data from a channel or field that has non-numeric points. Set 'OutputFormat' property to 'table' or 'timetable' to read non-numeric data. "

Probably due to that it is not uploaded to my channel with the thingSpeakWrite. If I read the same time period from fields 1 and 2 I manage to write that to my channel but for some reason fields 5 and 6 have a different format or what?

Could you please help me out here :).

data1 =

   30.9000       NaN
       NaN       NaN
       NaN       26.1000
       NaN       NaN
       NaN       NaN
       NaN       NaN
       NaN       NaN
   30.9000       NaN
       NaN       NaN
       NaN       NaN
       NaN       NaN
   30.8000       NaN
       NaN       NaN
       NaN       NaN
       NaN       NaN
       NaN       NaN

1 Comment

Christopher Stapels
Christopher Stapels on 22 Mar 2021

Have you tried using the thingSpeakRead(....'outputformat' 'timetable')? If there are values that MATLAB cant convert to numbers, it may not be able to read your data. If you use the timetable, you can get all the data in one read and analyze it how you like.

Can you tell us more about your final goal? (i.e. id like to visualize channel 4 data, channel 4 data is the temperature, its written every two hours from a Arduino device...etc)

Tags