Hi everyone, I'm trying to pass some objects (similar to the example below) at the CSV format but it's not going as planned. {"Numero":"BCUSA24PR04152024","Date":"15/04/2024","Code Journal":"GS","Exercice":24,"Compte":6515097,"Libelle":"Payroll Expenses:Gross Wages:Paul, Jeremy","Debit":6041.67,"C…

[image] pierredemay: The split node is used to ignore the "totals" line from my file I have no idea what that means - you have NOT provided a working demo flow (I do not have access to your file /Users/pierre.demay/Downloads/payroll.csv Please create a reproducible demo flow that highlights …

Is that enough? [{"id":"99e019d5.6f0748","type":"tab","label":"Payrolls","disabled":false,"info":"# Pay slips\n\n---\n\n## Context\n\nThis flow aims to **convert U.S. payrolls** into the format accepted by Akuiteo, the Braincube ERP.\n\nThe goal of this program is to **lighten the workload for U.S.…

[image] pierredemay: Is that enough? Perfect. Your issue is you are removing items between split and join What you should understand is the split nodes add info in msg.parts to aid the join node in understanding when all of the messages have been processed (this is detailed in the split a…

As I understand it: The flow input is a multi-line CSV file. It is split (into individual lines). After some manipulation local to each line, the line is written to another CSV file. So long as the file-out node is set to append, what is the point of having a join node? Delete the file at the st…

There are several issues I see You split the array but discard elements , to add to Steve's solutions, this can be solved also using recreate message sequence in the switch node. Your data element where Account Number equals "Totals" has no date or other info, this is messing with your JSONata. Sc…

[image] jbudd: So long as the file-out node is set to append, what is the point of having a join node? Delete the file at the start of the flow and append each line individually. The only disadvantage I see is that since the filename is being dynamically generated/provided, the file will be …

[image] E1cid: this can be solved also using recreate message sequence in the switch node A feature I've have never used nor read up on!

[image] Steve-Mcl: Here is a demo flow that does the 3rd option. Others may provide better solutions. By this, I change my flow and it works ! The only modification I do is to inject my file rather than 5 or 6 objects. The file is perfect but the debits and credits are a bit buggy : [Capt…

Alignment of numbers in a spreadsheet is often related to the value being considered a string or a number. Check the data BEFORE it goes into CSV node - do numbers look like numbers or strings? (numbers are shown in blue, strings in redish orange) and are USUALLY determined by the first row of data …

Unfortunately, this doesn't seem to be the solution. [Capture d’écran 2024-05-21 à 09.35.56] [Capture d’écran 2024-05-21 à 09.35.21]

Node-RED

Node-RED Forum

Missing values after passing through the csv node

General

E1cid 21 May 2024 15:30 29

JSONata is strict 0 != "0"

So you would not want to see the whole thing transformed in one JSONata expression?

1 Like

Topic		Replies	Views
Running a join node after filtering my messages General	5	96	11 September 2024
CSV format issues General	23	1299	8 March 2021
CSV node not respecting headers General csv	3	85	18 March 2025
String of data to file or CSV node General	10	445	31 August 2021
Problem with CSV import data parsing General	13	230	4 January 2024

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Missing values after passing through the csv node

Related topics