Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
DrGenious
Creator
Creator

Too many columns

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

 

Labels (2)
1 Solution

Accepted Solutions
DrGenious
Creator
Creator
Author

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

View solution in original post

5 Replies
Anonymous
Not applicable

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?

DrGenious
Creator
Creator
Author

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

0683p000009M8uy.png

Anonymous
Not applicable

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.

DrGenious
Creator
Creator
Author

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.

DrGenious
Creator
Creator
Author

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