I built a workflow to read all *.csv files in a folder into one file. The columns headers are all the same.
The CSV Reader node is setup as:
However, there is only one value missing from the output that exists in the input file:
I have confirmed that similar values are formatted exactly the same. Yet the others appear and this single value does not.
Does anyone know why this happens?
BTW, I created the same workflow using *.xls files as input and all values a present in the output, so it seems to be an issue with the CSV Reader.
Thanks for you help!