# How to output separate payload fields to text flows

**URL:** <https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436>\
**Category:** General\
**Created:** [28 May 2020 15:44 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436 "2020-05-28T15:44:11Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![node96](https://avatars.discourse-cdn.com/v4/letter/n/e480ec/32.png) [@node96](https://discourse.nodered.org/u/node96)\
**Post date:** [28 May 2020 15:44 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/1 "2020-05-28T15:44:12Z")

</div>

Hi,

I am sending a query that selects a max, min, avg, etc, in a database, and I want to send it to text flows separately that will show in the dashboard.

This is the payload data:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/c/7/c74929f0658648f879ce637c192a1e76bf32a76d.png)

And the flow:  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/e/6e11b53a859e307d9d83db1cff67d58926f5354c.png)

Thanks

---

<div class="post-metadata">

**Author:** ![JGKK](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/jgkk/32/18515_2.png) [@JGKK](https://discourse.nodered.org/u/JGKK)\
**Post date:** [28 May 2020 15:49 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/2 "2020-05-28T15:49:42Z")

</div>

hello,  
you can use one change node in front of every dashboard text node to set the msg.payload to the property of the msg object that you want to display. Just click on the little path icon next to the property in the debug tab to copy the path to that value and use it in the change node to set the payload to that value. I hope this makes sense.  
Johannes

---

<div class="post-metadata">

**Author:** ![node96](https://avatars.discourse-cdn.com/v4/letter/n/e480ec/32.png) [@node96](https://discourse.nodered.org/u/node96)\
**Post date:** [28 May 2020 16:00 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/3 "2020-05-28T16:00:31Z")

</div>

yes it worked, Thank you Johannes!! @JGKK

About the chart, can you give me some idea on how to do it?

---

<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:** [28 May 2020 16:33 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/4 "2020-05-28T16:33:34Z")

</div>

This (which is linked from the chart info tab) shows you the way the data must formatted to feed the chart.

> <https://github.com/node-red/node-red-dashboard/blob/master/Charts.md>

---

<div class="post-metadata">

**Author:** ![node96](https://avatars.discourse-cdn.com/v4/letter/n/e480ec/32.png) [@node96](https://discourse.nodered.org/u/node96)\
**Post date:** [28 May 2020 18:31 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/5 "2020-05-28T18:31:15Z")

</div>

doesn't really help me much...

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [28 May 2020 18:47 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/6 "2020-05-28T18:47:50Z")

</div>

Ifn your change nodes you can also set each msg.topic to a friendly name. You can then just feed all four into a single chart node as each topic will be plotted as a different colour

---

<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:** [28 May 2020 21:00 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/7 "2020-05-28T21:00:15Z")

</div>

> [@node96](#):
>
> doesn't really help me much

Have a look at the node red docs page Working with Messages. That will tell you lots of useful stuff about, oddly enough, working with messages.

---

<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:** [11 June 2020 21:00 UTC](https://discourse.nodered.org/t/how-to-output-separate-payload-fields-to-text-flows/27436/8 "2020-06-11T21:00:15Z")

</div>

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