# Bug in CSV node

**URL:** https://discourse.nodered.org/t/bug-in-csv-node/65364
**Category:** General
**Created:** [20 July 2022 13:24 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364 "2022-07-20T13:24:19Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![nke9](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nke9/32/46752_2.png) [@nke9](https://discourse.nodered.org/u/nke9)
#### Post date: [20 July 2022 13:24 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/1 "2022-07-20T13:24:19Z")

</div>

Hello I don't understand somtehing on the csv node.  
Here is my payload and the output of my csv node :  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/f/2/f2db91ad72441e071159cd5a0aad11f8aadf711a.png)  
And I want to change the columns folowing the different data of payload I receive  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/e/5/e5dd892288998649374314876f2575b4868a274e.png)  
But with the columns I configure I have the payload.cluster in the output of my csv node and I don't want to display it.

---

<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: [20 July 2022 14:17 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/2 "2022-07-20T14:17:35Z")

</div>

Are you able to share a small example flow with some example data so that we can import it and try it ?

---

<div class="post-metadata">

### Author: ![nke9](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nke9/32/46752_2.png) [@nke9](https://discourse.nodered.org/u/nke9)
#### Post date: [20 July 2022 14:33 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/3 "2022-07-20T14:33:21Z")

</div>

Yes here is an example of my problem :

`[{"id":"b5bf7afb.98cda8","type":"debug","z":"6bd6a2ca.53618c","name":"Debug general","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":800,"y":360,"wires":[]}]`

---

<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: [20 July 2022 14:43 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/4 "2022-07-20T14:43:05Z")

</div>

That is just a debug node... make sure you select all the relevant nodes before exporting.

---

<div class="post-metadata">

### Author: ![HaroldPetersInskipp](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/haroldpetersinskipp/32/42319_2.png) [@HaroldPetersInskipp](https://discourse.nodered.org/u/HaroldPetersInskipp)
#### Post date: [20 July 2022 15:10 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/5 "2022-07-20T15:10:38Z")

</div>

You could just delete that property by putting:

```auto
delete msg.payload.cluster;

```

In between lines 19 and 20

and move line 2 below your if statements so payload isn't set until after the property is deleted.

---

<div class="post-metadata">

### Author: ![nke9](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nke9/32/46752_2.png) [@nke9](https://discourse.nodered.org/u/nke9)
#### Post date: [21 July 2022 06:31 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/6 "2022-07-21T06:31:49Z")

</div>

Oh sorry here is the code :

```auto
[{"id":"984f86ea.b649c8","type":"inject","z":"6bd6a2ca.53618c","name":"","topic":"","payload":"{\"columns\":\"date,heure,humidity\",\"payload\":{\"date\":\"20/07/2022\",\"heure\":\"16:15:03\",\"cluster\":\"RelativeHumidity\",\"humidity\":48.53}}","payloadType":"json","repeat":"","crontab":"","once":false,"onceDelay":0.1,"x":410,"y":420,"wires":[["705d73cd.e1255c","dc41a30a.ee4dd"]]},{"id":"6fa49b1e.475114","type":"csv","z":"6bd6a2ca.53618c","name":"","sep":";","hdrin":false,"hdrout":false,"multi":"one","ret":"\\r\\n","temp":"","skip":"0","x":790,"y":420,"wires":[["17d770f0.781e5f"]]},{"id":"17d770f0.781e5f","type":"debug","z":"6bd6a2ca.53618c","name":"pay","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"payload","x":970,"y":420,"wires":[]},{"id":"b5bf7afb.98cda8","type":"debug","z":"6bd6a2ca.53618c","name":"Debug general","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":800,"y":360,"wires":[]},{"id":"705d73cd.e1255c","type":"function","z":"6bd6a2ca.53618c","name":"","func":"var colonne;\nvar payload = msg.payload.payload;\n\nif (msg.payload.payload.cluster == \"Clustertemperature\")\n{\n colonne = \"date,heure,temperature\";\n var columns = colonne;\n return {columns:columns,payload:payload}\n}\nelse if(msg.payload.payload.cluster == \"NodePowerDescriptor\")\n{\n colonne = \"date,heure,tension\";\n var columns = colonne;\n return {columns:columns,payload:payload}\n}\nelse if(msg.payload.payload.cluster == \"RelativeHumidity\")\n{\n colonne = \"date,heure,humidity\";\n var columns = colonne;\n return {columns:columns,payload:payload}\n}\nelse if(msg.payload.payload.cluster == \"AnalogInput\")\n{\n colonne = \"date,heure,courant\";\n var columns = colonne;\n return {columns:columns,payload:payload}\n}","outputs":1,"noerr":0,"x":610,"y":420,"wires":[["b5bf7afb.98cda8","6fa49b1e.475114","8fe0f494.755d98"]]},{"id":"8fe0f494.755d98","type":"debug","z":"6bd6a2ca.53618c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"columns","x":790,"y":480,"wires":[]},{"id":"dc41a30a.ee4dd","type":"debug","z":"6bd6a2ca.53618c","name":"","active":true,"tosidebar":true,"console":false,"tostatus":false,"complete":"true","x":540,"y":380,"wires":[]}]

```

---

<div class="post-metadata">

### Author: ![nke9](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/nke9/32/46752_2.png) [@nke9](https://discourse.nodered.org/u/nke9)
#### Post date: [21 July 2022 06:40 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/7 "2022-07-21T06:40:46Z")

</div>

I'm going to to test this thanks you

---

<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: [19 September 2022 06:41 UTC](https://discourse.nodered.org/t/bug-in-csv-node/65364/8 "2022-09-19T06:41:44Z")

</div>

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