Add array object value from two arrays and return one array with the add values

General
1

Hello,

is it possible to add an object value from two arrays without changing the other objects in the array? The two arrays should become one array.

Test1
Test1351Ă—837 19.7 KB

2

Try using concat

I created a flow that should help you understand.

Import this flow:

[{"id":"3bda0a600cf55ec4","type":"function","z":"d2add6885c98847b","name":"Create array of arrays of objects","func":"msg.payload = [\n    [\n        {\n        a:01,\n        b:02,\n        c:03,\n        d:04,\n        e:05,\n        f:06,\n        g:07,\n        h:08,\n        i:09,\n        j:10\n        },\n        {\n        A:101,\n        B:102,\n        C:103,\n        D:104,\n        E:105,\n        F:106,\n        G:107,\n        H:108,\n        I:109,\n        J:110\n        }\n    ]\n    ,\n    [\n        {\n        aaa:201,\n        bbb:202,\n        ccc:203,\n        ddd:204,\n        eee:205,\n        fff:206,\n        ggg:207,\n        hhh:208,\n        iii:209,\n        jjj:210\n        },\n        {\n        AAA:301,\n        BBB:302,\n        CCC:303,\n        DDD:304,\n        EEE:305,\n        FFF:306,\n        GGG:307,\n        HHH:308,\n        III:309,\n        JJJ:310\n        }\n    ]\n\n\n\n]\nreturn msg;\n\n","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":430,"y":180,"wires":[["0d375a61e1a57692","29a7ea2c0d75f106"]]},{"id":"016770477dcad19c","type":"inject","z":"d2add6885c98847b","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":200,"y":200,"wires":[["3bda0a600cf55ec4"]]},{"id":"ad7b5624ee7dab01","type":"debug","z":"d2add6885c98847b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":670,"y":220,"wires":[]},{"id":"0d375a61e1a57692","type":"function","z":"d2add6885c98847b","name":"concat arrays","func":"const originalPayload = msg.payload;\nconst newPayload = [].concat(...originalPayload);\nmsg.payload = newPayload;\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","libs":[],"x":420,"y":220,"wires":[["ad7b5624ee7dab01"]]},{"id":"29a7ea2c0d75f106","type":"debug","z":"d2add6885c98847b","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","targetType":"full","statusVal":"","statusType":"auto","x":670,"y":180,"wires":[]}]

Screenshot from 2022-03-14 01-53-18
Screenshot from 2022-03-14 01-53-18820Ă—642 52.5 KB

It helps if you copy the payload and paste it for us to use. Then we can test it with your values ...FYI
Screenshot from 2022-03-14 01-57-54

This saves us from having to recreate your payload IE: Create array of arrays of objects

3

The concat() method is used to merge two or more arrays.

I know that I can merge two arrays with it. But what I want is something else. I want to add the "purple" values and return the whole thing as one array. I am not interested in the rest of the second array.

Here is the payload:

[[{"Datum/Uhrzeit":"00:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"07:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"07:15","Verbrauchswert":"1,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"07:30","Verbrauchswert":"3,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,002"},{"Datum/Uhrzeit":"07:45","Verbrauchswert":"9,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,005"},{"Datum/Uhrzeit":"08:00","Verbrauchswert":"15,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,008"},{"Datum/Uhrzeit":"08:15","Verbrauchswert":"16,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,009"},{"Datum/Uhrzeit":"08:30","Verbrauchswert":"21,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,012"},{"Datum/Uhrzeit":"08:45","Verbrauchswert":"30,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,017"},{"Datum/Uhrzeit":"09:00","Verbrauchswert":"33,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,018"},{"Datum/Uhrzeit":"09:15","Verbrauchswert":"40,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,022"},{"Datum/Uhrzeit":"09:30","Verbrauchswert":"44,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,024"},{"Datum/Uhrzeit":"09:45","Verbrauchswert":"48,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,026"},{"Datum/Uhrzeit":"10:00","Verbrauchswert":"52,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,029"},{"Datum/Uhrzeit":"10:15","Verbrauchswert":"55,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,030"},{"Datum/Uhrzeit":"10:30","Verbrauchswert":"57,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,031"},{"Datum/Uhrzeit":"10:45","Verbrauchswert":"57,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,031"},{"Datum/Uhrzeit":"11:00","Verbrauchswert":"59,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,032"},{"Datum/Uhrzeit":"11:15","Verbrauchswert":"63,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,035"},{"Datum/Uhrzeit":"11:30","Verbrauchswert":"59,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,032"},{"Datum/Uhrzeit":"11:45","Verbrauchswert":"57,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,031"},{"Datum/Uhrzeit":"12:00","Verbrauchswert":"43,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,024"},{"Datum/Uhrzeit":"12:15","Verbrauchswert":"46,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,025"},{"Datum/Uhrzeit":"12:30","Verbrauchswert":"51,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,028"},{"Datum/Uhrzeit":"12:45","Verbrauchswert":"52,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,029"},{"Datum/Uhrzeit":"13:00","Verbrauchswert":"67,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,037"},{"Datum/Uhrzeit":"13:15","Verbrauchswert":"36,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,020"},{"Datum/Uhrzeit":"13:30","Verbrauchswert":"50,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,028"},{"Datum/Uhrzeit":"13:45","Verbrauchswert":"66,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,036"},{"Datum/Uhrzeit":"14:00","Verbrauchswert":"62,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,034"},{"Datum/Uhrzeit":"14:15","Verbrauchswert":"61,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,034"},{"Datum/Uhrzeit":"14:30","Verbrauchswert":"57,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,031"},{"Datum/Uhrzeit":"14:45","Verbrauchswert":"55,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,030"},{"Datum/Uhrzeit":"15:00","Verbrauchswert":"53,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,029"},{"Datum/Uhrzeit":"15:15","Verbrauchswert":"48,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,026"},{"Datum/Uhrzeit":"15:30","Verbrauchswert":"41,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,023"},{"Datum/Uhrzeit":"15:45","Verbrauchswert":"34,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,019"},{"Datum/Uhrzeit":"16:00","Verbrauchswert":"29,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,016"},{"Datum/Uhrzeit":"16:15","Verbrauchswert":"18,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,010"},{"Datum/Uhrzeit":"16:30","Verbrauchswert":"8,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,004"},{"Datum/Uhrzeit":"16:45","Verbrauchswert":"6,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,003"},{"Datum/Uhrzeit":"17:00","Verbrauchswert":"5,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,003"},{"Datum/Uhrzeit":"17:15","Verbrauchswert":"3,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,002"},{"Datum/Uhrzeit":"17:30","Verbrauchswert":"1,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"17:45","Verbrauchswert":"1,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"18:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"}],[{"Datum/Uhrzeit":"00:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"00:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"01:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"02:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"03:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"04:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"05:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"06:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"07:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"07:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"07:30","Verbrauchswert":"1,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"07:45","Verbrauchswert":"3,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,002"},{"Datum/Uhrzeit":"08:00","Verbrauchswert":"3,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,002"},{"Datum/Uhrzeit":"08:15","Verbrauchswert":"6,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,003"},{"Datum/Uhrzeit":"08:30","Verbrauchswert":"8,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,004"},{"Datum/Uhrzeit":"08:45","Verbrauchswert":"7,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,004"},{"Datum/Uhrzeit":"09:00","Verbrauchswert":"10,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,006"},{"Datum/Uhrzeit":"09:15","Verbrauchswert":"10,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,006"},{"Datum/Uhrzeit":"09:30","Verbrauchswert":"9,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,005"},{"Datum/Uhrzeit":"09:45","Verbrauchswert":"9,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,005"},{"Datum/Uhrzeit":"10:00","Verbrauchswert":"12,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"10:15","Verbrauchswert":"13,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"10:30","Verbrauchswert":"12,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"10:45","Verbrauchswert":"13,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"11:00","Verbrauchswert":"11,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,006"},{"Datum/Uhrzeit":"11:15","Verbrauchswert":"13,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"11:30","Verbrauchswert":"14,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,008"},{"Datum/Uhrzeit":"11:45","Verbrauchswert":"11,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,006"},{"Datum/Uhrzeit":"12:00","Verbrauchswert":"11,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,006"},{"Datum/Uhrzeit":"12:15","Verbrauchswert":"13,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"12:30","Verbrauchswert":"18,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,010"},{"Datum/Uhrzeit":"12:45","Verbrauchswert":"17,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,009"},{"Datum/Uhrzeit":"13:00","Verbrauchswert":"14,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,008"},{"Datum/Uhrzeit":"13:15","Verbrauchswert":"18,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,010"},{"Datum/Uhrzeit":"13:30","Verbrauchswert":"17,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,009"},{"Datum/Uhrzeit":"13:45","Verbrauchswert":"16,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,009"},{"Datum/Uhrzeit":"14:00","Verbrauchswert":"12,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"14:15","Verbrauchswert":"15,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,008"},{"Datum/Uhrzeit":"14:30","Verbrauchswert":"13,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,007"},{"Datum/Uhrzeit":"14:45","Verbrauchswert":"15,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,008"},{"Datum/Uhrzeit":"15:00","Verbrauchswert":"48,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,026"},{"Datum/Uhrzeit":"15:15","Verbrauchswert":"48,000","Einheit":"kg CO2","Verbrauch in Euro":"0,02","CO2-Ausstoss":"0,026"},{"Datum/Uhrzeit":"15:30","Verbrauchswert":"44,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,024"},{"Datum/Uhrzeit":"15:45","Verbrauchswert":"38,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,021"},{"Datum/Uhrzeit":"16:00","Verbrauchswert":"35,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,019"},{"Datum/Uhrzeit":"16:15","Verbrauchswert":"29,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,016"},{"Datum/Uhrzeit":"16:30","Verbrauchswert":"23,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,013"},{"Datum/Uhrzeit":"16:45","Verbrauchswert":"19,000","Einheit":"kg CO2","Verbrauch in Euro":"0,01","CO2-Ausstoss":"0,010"},{"Datum/Uhrzeit":"17:00","Verbrauchswert":"8,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,004"},{"Datum/Uhrzeit":"17:15","Verbrauchswert":"2,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"17:30","Verbrauchswert":"2,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"17:45","Verbrauchswert":"1,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,001"},{"Datum/Uhrzeit":"18:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"18:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"19:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"20:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"21:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"22:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:00","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:15","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:30","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"},{"Datum/Uhrzeit":"23:45","Verbrauchswert":"0,000","Einheit":"kg CO2","Verbrauch in Euro":"0,00","CO2-Ausstoss":"0,000"}]]

Thanks for helping me.

4

Possible, but it does not help that your values are strings and contain commas. Something like this should do it.

[{"id":"016770477dcad19c","type":"inject","z":"bf9e1e33.030598","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"[[{\"Datum/Uhrzeit\":\"00:00\",\"Verbrauchswert\":\"0,100\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"},{\"Datum/Uhrzeit\":\"00:15\",\"Verbrauchswert\":\"0,200\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"},{\"Datum/Uhrzeit\":\"00:30\",\"Verbrauchswert\":\"0,300\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"}],[{\"Datum/Uhrzeit\":\"00:00\",\"Verbrauchswert\":\"0,100\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"},{\"Datum/Uhrzeit\":\"00:15\",\"Verbrauchswert\":\"0,200\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"},{\"Datum/Uhrzeit\":\"00:30\",\"Verbrauchswert\":\"0,300\",\"Einheit\":\"kg CO2\",\"Verbrauch in Euro\":\"0,00\",\"CO2-Ausstoss\":\"0,000\"}]]","payloadType":"json","x":110,"y":2020,"wires":[["317bc371.8b0cd4"]]},{"id":"317bc371.8b0cd4","type":"function","z":"bf9e1e33.030598","name":"","func":"let output = msg.payload[0];\nfor(let j = 0; j < msg.payload[0].length; j++){\n    output[j].Verbrauchswert = parseFloat(output[j].Verbrauchswert.replace(\",\", \".\")) \n    for(let i = 1; i < msg.payload.length; i++){\n        output[j].Verbrauchswert += \n            parseFloat(msg.payload[i][j].Verbrauchswert.replace(\",\", \".\"));\n    }\n    output[j].Verbrauchswert = output[j].Verbrauchswert.toFixed(3).replace(\".\", \",\");\n}\nmsg.payload = output\nreturn msg;","outputs":1,"noerr":0,"initialize":"","finalize":"","x":360,"y":2020,"wires":[["29a7ea2c0d75f106"]]},{"id":"29a7ea2c0d75f106","type":"debug","z":"bf9e1e33.030598","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","targetType":"msg","statusVal":"","statusType":"auto","x":640,"y":2000,"wires":[]}]
5

I totally overlooked the fact that the value is a string. Now the summation of the values works. Small things can be crucial :wink: Thanks for the help!

2 Likes
6

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.