# Read CSV DATA one by One

**URL:** <https://discourse.nodered.org/t/read-csv-data-one-by-one/5797>\
**Category:** General\
**Created:** [14 December 2018 08:43 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797 "2018-12-14T08:43:53Z")\
**Posts on this page:** 14\
**Page:** 1

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 08:43 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/1 "2018-12-14T08:43:53Z")

</div>

Hi may I ask how Im going to output data from csv with time interval for each rows.  
My problem is im able to out put all the data all at once.  
Thank you

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [14 December 2018 08:50 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/2 "2018-12-14T08:50:32Z")

</div>

Are you reading this from a file? If so take a look at the options on the file-in node

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 08:52 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/3 "2018-12-14T08:52:33Z")

</div>

Yes I am. MY problem is that after reading the csv file. E.g I have 35 rows. It will output all the 35 rows simultaneously. Im expecting it to be output 5sec per row.

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 08:57 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/4 "2018-12-14T08:57:02Z")

</div>

Sorry Im just a newbie here in Node-red. IF you can give me some example much appreciated.

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [14 December 2018 08:58 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/5 "2018-12-14T08:58:08Z")

</div>

> [@iannaco06](#):
>
> Im expecting it to be output 5sec per row.

You can add a Delay node after the File node, and configure it to Rate Limiting mode - then pick the message rate you want.

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 09:02 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/6 "2018-12-14T09:02:27Z")

</div>

after I placed the delay node after the file node it only delay the first row after that all the other rows output simultaneously without any delay

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [14 December 2018 09:02 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/7 "2018-12-14T09:02:57Z")

</div>

Then you have not configured it in Rate Limiting mode as I suggested.

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 09:05 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/8 "2018-12-14T09:05:57Z")

</div>

i configured it "1 msg per 1 sec"  
my node -\> File Node -\> Delay Node -\> CSV NODE -\> Function Node -\> Debug Node

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 09:12 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/9 "2018-12-14T09:12:05Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/5/5da34d709fab015987332f3378ffa03a51910d8c.png)

---

<div class="post-metadata">

**Author:** ![iannaco06](https://avatars.discourse-cdn.com/v4/letter/i/9f8e36/32.png) [@iannaco06](https://discourse.nodered.org/u/iannaco06)\
**Post date:** [14 December 2018 09:13 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/10 "2018-12-14T09:13:32Z")

</div>

only the first row meet the delay node

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/2X/d/d0e5a45dbbd8323293fb0d6e9601ccc08a322a37.png)

---

<div class="post-metadata">

**Author:** ![ukmoose](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/ukmoose/32/13_2.png) [@ukmoose](https://discourse.nodered.org/u/ukmoose)\
**Post date:** [14 December 2018 09:44 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/11 "2018-12-14T09:44:15Z")

</div>

you’ve set the delay node the limit topic.  
So does your message have a topic?

If not try changing the configuration of the delay node

---

<div class="post-metadata">

**Author:** ![sarawut](https://avatars.discourse-cdn.com/v4/letter/s/848f3c/32.png) [@sarawut](https://discourse.nodered.org/u/sarawut)\
**Post date:** [31 March 2020 04:26 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/12 "2020-03-31T04:26:39Z")

</div>

Please help me for CSV file after send by S7. How to record data continue. Now i saw in csv file like this  
 ![wwwwwww](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/d/b/db4ffd1709870acfbb9f237bd7e6cff0e482556c.png)

I want only head columm on top don't want every data get name of columm

Please help me

---

<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:** [31 March 2020 09:27 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/13 "2020-03-31T09:27:16Z")

</div>

answered in this new thread - [How to setting data continue](https://discourse.nodered.org/t/how-to-setting-data-continue/23939)

---

<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:** [31 March 2020 09:27 UTC](https://discourse.nodered.org/t/read-csv-data-one-by-one/5797/14 "2020-03-31T09:27:23Z")

</div>


