I am trying to transform processed data from a function node to a spreadsheet with the help of the spreadsheet node.
However, I am unable to receive anything from the spreadsheet node, which isn’t flat.
I created an array of rows, from which the first one should be the headline.
[“headline1”,“headline2”][“data row 1”,“data row 1 second variable”] …
Instead of having a table, the first row indicates just where the data comes from
“data.0.0 data.0.1 data.0.2 data.0.3 data.0.4 data.0.5 data.0.6 data.1.0 data.1.1 data.1.2 data.1.3 data.1.4 data.1.5”
and the actual data is line 2.
How does the spreadsheet node expect the data to be formatted?
Your example does work. BUT:
I tried it as “array of objects” before but can’t get it to work.
I process my object somewhere else and just want to pass it on.
If i return it as “array with json” it turns out as described above already. Just altered your example slightly.
The data it’s not returned the right way. Check the example below. You are putting the array on the JSON property, but each row of the array should be under an individual JSON property.