topic Re: Too many columns in Talend Studio

Too many columns

DrGenious — Wed, 29 Jan 2020 09:54:26 GMT

Hey,

I am trying to parse a file. When I check the "Check each row structure against schema" in advance settings some rows have the message "Too many columns", but when I put the schemaCompliance component it doesnt show me an error message.Why is this happen?

Also in one column my values are comma seperated but my file is also comma seperated. For example the value is " Nick , joe,25;USA,student".

Re: Too many columns

Anonymous — Wed, 29 Jan 2020 12:01:42 GMT

Can you give screenshots of what you are seeing please? Also, your example of the column which has commas in it, is it surrounded by "" in the file? Can you give an example of one row in the file EXACTLY as it appears in the file?

Re: Too many columns

DrGenious — Wed, 29 Jan 2020 12:06:38 GMT

@rhall

Hey, thanks for the quick response.

In my file it is like this

Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone

And when I printed it is like this

I want all this "Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone"

to be only in AccessDevice column not to seperated in other columns.

Re: Too many columns

Anonymous — Wed, 29 Jan 2020 12:21:42 GMT

I see. You haven't give me an example of a complete row of your file though. I can only assume (by the quote in your AccessDevice and Host columns) that your values are wrapped in quotes. Try ticking the CSV options tickbox in your tFileInputDelimited component.

Re: Too many columns

DrGenious — Wed, 29 Jan 2020 13:10:27 GMT

The row is : Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone,FALSE,SSL
And I want the "Galaxy A5 (2016) Duos A510FD,Samsung,GSM;35262508,Android,Smartphone" to be in AccessDevice and do not split in other columns like in the photo that I mentioned before .

I ticked the box but nothing happened.

Re: Too many columns

DrGenious — Wed, 29 Jan 2020 13:25:19 GMT

I figured it out. I had to check the box like you said and on the Text Enclosure " " " (with no space) .