Pentaho | Issue with CSV file to Table output

Question

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..

which delimeter should I use? I used , but it is not working..Values are getting shifted to next column. — Nilesh Patil
– Nilesh Patil, Commented Nov 14, 2016 at 12:06

Srini V · Accepted Answer · 2016-11-14 12:32:03Z

1

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.

answered Nov 14, 2016 at 12:32

Srini V

11.5k15 gold badges70 silver badges93 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Nilesh Patil Over a year ago

Thank you so much!!

Srini V Over a year ago

@NileshPatil If this resolves your issue, please mark this as a correct answer and close this thread. Or if you feel something more is needed although this is helpful, you can upvote this answer and refine your question.

Nilesh Patil Over a year ago

Hello, Thanks for your help. Yes, issue is resolved now.

NK0709 · Accepted Answer · 2020-02-24 02:41:29Z

0

you can change the delimiter say to PIPE and also keeping data as quoted text like "1,Name" this will treat the same as 1 column

answered Feb 24, 2020 at 2:41

NK0709

664 bronze badges

Collectives™ on Stack Overflow

Pentaho | Issue with CSV file to Table output

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related