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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save an extra $150 Dec 1–7 with code CYBERWEEK - stackable with early bird savings: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2010-12-24 12:24 AM

Column(s) missing error

Hi Guys,
I am parsing a large csv file of 1GB data.It has some 10 columns seperated by ";" in it. Records are delimited by newline.I am only picking 3 of those columns from the input csv & the others gets rejected automatically in tmap.Now i am getting this unusual error or "Column(s) Missing".PFA the screenshot.But my job gets completed & i get the desired output.I want to know why is this error coming.Please help,i am not able to resolve this!!!
Thanks,
Neeraj
Labels (2)
Labels
245 Views
0 Likes
1 Reply
alevy
Specialist
Specialist
‎2010-12-25 06:29 AM

I would guess that you've checked the advanced option "Check columns against schema" (or something like that; I'm not on a PC with the studio installed at the moment 0683p000009MACn.png) and unchecked the "Die on error" option. Then there are lines in your input file that do not have all 10 columns. You can connect a reject flow from your tFileInputDelimited to e.g. tLogRow to see what they do contain.
245 Views
0 Likes