Bulk update with thingSpeakWrite to a specified field

In the thingSpeakWrite documentation is an example, how to upload a table of data

....
    thingSpeakWrite(writeChannelID,dataTable,'WriteKey',writeAPIKey);

This works, but the data are uploaded in Field1. How can i specifie the field - for example field 5?

thingSpeakWrite(writeChannelID,'Fields',[5],dataTable,'WriteKey',writeAPIKey);

or

thingSpeakWrite(writeChannelID,'Fields',[5],'Values',dataTable,'WriteKey',writeAPIKey);

did not work.

Answer 1

[Christopher Stapels]

myDates=datetime(2023,1,1):days(1):datetime(2023,1,10)
nullVec=string.empty(10,0);
myNums=1:10;
myTimeTable=table(myDates',nullVec,nullVec,nullVec,nullVec,myNums')
thingSpeakWrite(nnnnnnnnn,myTimeTable,'writeKey','xxxxxxxxxxxxxxxx')

[Manfred]

Thank you for your great help!

Answer 2

[Christopher Stapels]

Make your data table with the first four columns of null values.

[Manfred]

i tryed

dataField = [null,null,null,null,1;null,null,null,null,2;null,null,null,null,3;null,null,null,null,4;null,null,null,null,5;null,null,null,null,6;null,null,null,null,7;null,null,null,null,8;null,null,null,null,9;null,null,null,null,10];

and

dataField = [,,,,1;,,,,2;,,,,3;,,,,4;,,,,5;,,,,6;,,,,7;,,,,8;,,,,9;,,,,10];

and got the Error:

"Invalid expression. When calling a function or indexing a variable, use parentheses. Otherwise, check for mismatched delimiters."