# Adding values after a join object

**URL:** <https://discourse.nodered.org/t/adding-values-after-a-join-object/34042>\
**Category:** General\
**Created:** [10 October 2020 10:32 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042 "2020-10-10T10:32:44Z")\
**Posts on this page:** 11\
**Page:** 1

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [10 October 2020 10:32 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/1 "2020-10-10T10:32:44Z")

</div>

Hi,  
I want to add some values but I don´t find the mistake why it doesn't work.

after the join I get 2 objects:

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/9/f983bb928f14817c15b88b25a86fd6c5914d759c.png)  
I can only work with the values of the first object "PAC1" and "PAC2", the values in the object ["f52b72ff.9cc7"] are not available. I don´t know why.

the values from the object "f52b72ff.9cc7" comes diect from the output of the buffer parser:

 ![grafik](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/f/8f8b38ee51359acce2f28fb379f039993888e475.png)

---

<div class="post-metadata">

**Author:** ![zenofmud](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zenofmud/32/316_2.png) [@zenofmud](https://discourse.nodered.org/u/zenofmud)\
**Post date:** [10 October 2020 11:00 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/2 "2020-10-10T11:00:05Z")

</div>

First off might I offer you a suggestion...if you added some link nodes your flow wouldn't look so confusing.

Not having the actual flow, the pitcure seems to indicate there are threemsg's able to get to the join.

You say the ` the values in the object ["f52b72ff.9cc7"] are not available`. I see no reference to that object is what you have provided.

My second suggestion is you add a `debug` node to the output of each of the nodes connected to the join. Once you have captured the data, you could create a small flow where you have three `inject` nodes setting up msgs with the data you captured in the `debug` nodes and feed that into a copy of the `join` node and connect that to a `debug` node.

That way you could provide a small flow that reproduces your issue and make it easier for someone to help you.

---

<div class="post-metadata">

**Author:** ![E1cid](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/e1cid/32/77971_2.png) [@E1cid](https://discourse.nodered.org/u/E1cid)\
**Post date:** [10 October 2020 11:05 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/3 "2020-10-10T11:05:10Z")

</div>

How are you trying to access the object?

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [10 October 2020 11:12 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/4 "2020-10-10T11:12:09Z")

</div>

sorry for that chaos.  
I solved it another way: after the buffer parser I extracted each value I need in a function node:

```auto
msg.payload = msg.payload.PACeinL1
msg.topic = "PACeinL1"
return msg;

```

I joined all of these with no problem.

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [10 October 2020 15:25 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/5 "2020-10-10T15:25:13Z")

</div>

but I would still be interested in how I get the values that are in the object "f52b72ff.9cc7" you can see in the first picture (UL1 .... Qges).

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2020 15:41 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/6 "2020-10-10T15:41:14Z")

</div>

Because the name has a dot in it you cannot use the shorthand method of access by something like `msg.payload.f5blabla.9c7.UL1`. You have to use `msg.payload["f5blabla.9c7"].UL1`

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [10 October 2020 17:27 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/7 "2020-10-10T17:27:31Z")

</div>

thank you  
do you know how I could rename the object topic in something other `f5blabla.9c7"` -\> "obj1"

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [10 October 2020 17:46 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/8 "2020-10-10T17:46:39Z")

</div>

Put a change node before the join node that Sets msg.topic to whatever you want.  
Where does that topic come from originally?

---

<div class="post-metadata">

**Author:** ![Becker](https://avatars.discourse-cdn.com/v4/letter/b/c77e96/32.png) [@Becker](https://discourse.nodered.org/u/Becker)\
**Post date:** [11 October 2020 14:45 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/9 "2020-10-11T14:45:13Z")

</div>

from the buffer parser

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [11 October 2020 15:43 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/10 "2020-10-11T15:43:18Z")

</div>

Did you look at the help text for that node to find why the topic is set to that? Looking there I see  
" **set topic** When false, `msg.topic` will be unmodified. When true, `msg.topic` will be set to the value of `name`"  
So I deduce from that that you have selected Set Topic in the nodes config, but have not given the node a name, so the topic is defaulting to the node's id. The solution is therefore to give the node a name, or if the incoming message has a meaningful topic then deselect Set Topic so that topic will be passed through. It is generally good practice to give nodes a name anyway, in order to help with debugging and also to make the flow more readable.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [25 October 2020 15:43 UTC](https://discourse.nodered.org/t/adding-values-after-a-join-object/34042/11 "2020-10-25T15:43:20Z")

</div>

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