I am generating several csv that I want to merge into one so that I can send it by email, The idea is that when pressing the timestamp I take the files I want from the path and merge them into 1 sooo, I have looked at how to do it with python and I could do it with the python node but I would like …

There are probably easier methods, but you could try this flow: [{"id":"3a79ae2c.9908ea","type":"inject","z":"6bf9fb85.abde3c","name":"","props":[{"p":"payload"},{"p":"topic","vt":"str"}],"repeat":"","crontab":"","once":false,"onceDelay":0.1,"topic":"","payload":"","payloadType":"date","x":132,"y":…

It works perfect, could you clarify what the join and batch node is used for?

Yes, it is to save temporary data, I have values in the plc that are updated and crushed every 8 hours, the idea is to record the values of these variables within those 8 hours through the pulses of the 2 Boolean inputs, which are the ones that tell me to record when the data has changed, when 8…

When I have everything working, I will upload a capture and the flow in case it is of interest to a colleague.

[image] osancleca: Yes, it is to save temporary data, You could use persistent context instead, almost certainly that would be simpler. https://nodered.org/docs/user-guide/context

How to merge multiple csv into one

General

Colin 31 August 2020 12:30 3

I think it might be worth your while explaining what you are doing with the csv files in this thread and the previous one. Are you using the csv files just for temporary storage? If so then there are probably much easier ways of solving your problems.

Topic		Replies	Views
Merging 2 csv files in Node-RED/JavaScript General	3	808	4 December 2020
Merging 2 csv LEFT JOIN General	11	980	3 August 2021
Select files within a date range and merge them into one file General	21	1428	13 May 2022
Add multiple outputs to one line in a csv file General	2	145	22 May 2023
Beginner - merge 2 CSV files containing time stamp and temperature to one chart General	3	218	22 March 2023

How to merge multiple csv into one

Related topics