When you add the CSV reader you first click on the Parameters button so it reads the file and maps the attributes.
It is preferable to have a Header in your first row
Can you share a part of the CSV? If your delimiter is also used in the values, it could become very messy when using auto. Usually the parameters should give you enough control to fix this.
When you add the CSV reader you first click on the Parameters button so it reads the file and maps the attributes.
It is preferable to have a Header in your first row
This worked! I think I was trying to alter the parameters after the reader had already been added which wasn't working but when I did it when I added the reader it worked. Thanks!
Can you share a part of the CSV? If your delimiter is also used in the values, it could become very messy when using auto. Usually the parameters should give you enough control to fix this.
thanks for your suggestion! It was the auto parameter that caused it, it worked when I altered the parameters while adding the reader. Thanks for your help