Sort msg.payload Arrays into sections

Navybrandon · 1 November 2019 15:06

Hello Everyone,

Thanks in advance for everyone that helps here!

Issue: I have msg.payload1.value.values that has over 100 arrays. I am wondering how to I output the data in sections like node red does? See pic below. My end goal is to have this data display in the dashboard in blocks of 10.

bakman2 · 1 November 2019 15:19

You can use the counter in a for loop to jump to the next "chunck" of the array and slice it:

Example

//example payload
[{"value":1},{"value":5},{"value":3},{"value":8},{"value":11},{"value":722}]

in function node


m = msg.payload
let i,j,t,c=2; // c = chunk/split by

for (i=0,j=m.length; i<j; i+=c) {
    t = m.slice(i,i+c);
    node.send({payload:t})
}

Output

msg.payload
[{"value":1},{"value":5}]
....

Navybrandon · 1 November 2019 15:43

Thank you bakman2,

But when I run this in the function i get an error stating length is undefined.

meeki007 · 1 November 2019 15:45

Please see:

array.map

also threads I've written that use the array.map method that might help you.

Populate data from database into Dropdownlist

Help with my flow: generating an email from array

I am now working on a solution for you. ...... I've become the array.map guy........lord help me

Navybrandon · 1 November 2019 15:53

meeki007

this is awesome this is what i was looking for! Sorry i missed this how to earlier when i searched. love the ui dropdown as well that's where i was heading. But when i tested the flow i got an error saying msg.payload.map is not a function.

hotNipi · 1 November 2019 15:53

If you really have this line in your function

m = msg.payload

Then there is no variable named m declared and you cant ask value of the .length property from not declared thing.
To do it properly it needs to be

let m = msg.payload

Navybrandon · 1 November 2019 15:56

even after adding let to the function, it still does not understand m.length of undefined.

hotNipi · 1 November 2019 15:58

But what is in the msg.payload ?
Do this in first line

node.warn('this is payload:'+msg.payload)

And see debug tab

bakman2 · 1 November 2019 16:05

It was an example.

Your payload is: msg.payload1.value.values

To do it properly it needs to be

You don't "need" to define variables in javascript

Navybrandon · 1 November 2019 16:08

right I ran the function with msg.payload1.value.values and got the error.

meeki007 · 1 November 2019 16:09

@Navybrandon

Hang in there I'm working on helping you out right now.

It may take me an hour but I have the rest of the day off and I will not leave you hanging on this. Its become my goal to teach all my favourite method in JS

bakman2 · 1 November 2019 16:10

You will have to redefine the values to the values of your array ofcourse.

Navybrandon · 1 November 2019 16:12

bakman2

Navybrandon · 1 November 2019 16:13

meeki007

I look forward in studying with you Jedi master lol

again thank you!

bakman2 · 1 November 2019 16:13

So what does your function look like ?

And show the actual values in your array objects.

Navybrandon · 1 November 2019 16:14

@meeki007 would you like me to dump the msg.payload into a log so you can import it?

Navybrandon · 1 November 2019 16:14

@bakman2

Navybrandon · 1 November 2019 16:15

Also note the amount of arrays will vary as well.

bakman2 · 1 November 2019 16:16

Exactly, that won't work.

Show your msg.payload
in text (or attachment) please not screenshots

Navybrandon · 1 November 2019 16:16

Topic		Replies	Views
Trying to refer to parts in an array without undefined error? General	4	469	30 January 2021
Msg array to individual objects General	5	189	10 February 2023
Hello how to division msg.payload value /10 Dashboard function-node	9	255	30 November 2023
[SOLVED] Msg.payload : objects to string in a sentence (need help !) General	5	4781	30 March 2020
Converting Object to Array General function-node	5	1254	15 July 2022

Sort msg.payload Arrays into sections

Related Topics