3 Replies Latest reply: Mar 5, 2015 9:38 AM by Andrew Whitfield RSS

    Reading data for CSV generates ',' for last column

      Dear All,

       

      I am trying to load data from a CSV file that has 6 columns. When I look at the File Wizard, the last column has a comma (',') appended to the column title as well as all the column values. This happens only to the last column.

       

       

      Even if I trying changing the Characterset to UTF-8 or other format, the commas are still present.

       

      I do not see these commas in the source CSV file. Can someone let me know why these commas do occur in the data when they are absent in source data ?