pentahopentaho-cdepentaho-spoonpentaho-design-studiopentaho-ctools

Pentaho | Issue with CSV file to Table output


I am working in Pentaho spoon. I have a requirement to load CSV file data into one table.

I have used , as delimter in CSV file. I can see correct data in preview of CSV file input step. But when I tried to insert data into Table Output step, I am getting data truncation error.

This is because I have below kind of values in one of my column. "2,ABC Squere".

As you see, I have "," in my column value so it is truncating and throwing error.How to solve this problem?

I want to upload data in Table with this kind of values..


Solution

  • Here is one way of doing it

    test.csv
    --------
    colA,colB,colC
    ABC,"2,ABC Squere",test
    

    See below the settings. The key is to use "" as encloser and , as delimiter.

    enter image description here