Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

michael_gardner
Not applicable

Only the first record of table not loading properly

The very first record of my Table is "FY2009".  QlikView understands to ignore the double quotes for all records except the first one as seen in the image below.  Why is this happening and how can I resolve this?

Image 1.png

1 Solution

Accepted Solutions
Not applicable

Re: Only the first record of table not loading properly

Maybe there is a hidden character before the first "FY2009"? I don't have Notepad++ but I think there's an option to show the hidden characters or to view it in hex mode.

You could then strip it out in the load script using replace() and char().

5 Replies
Not applicable

Re: Only the first record of table not loading properly

Maybe there is a hidden character before the first "FY2009"? I don't have Notepad++ but I think there's an option to show the hidden characters or to view it in hex mode.

You could then strip it out in the load script using replace() and char().

alexandros17
Not applicable

Re: Only the first record of table not loading properly

I suppose that the first record is interpreted as header (to avoid this, when you import data uncheck "first row as header")

Hope this helps

michael_gardner
Not applicable

Re: Only the first record of table not loading properly

This is what it looks like in the Wizard.

Image 1.png

Not applicable

Re: Only the first record of table not loading properly

Are you able to share the csv with us (only first few rows needed)?

michael_gardner
Not applicable

Re: Only the first record of table not loading properly

Thanks that seemed to do the trick.  I d/l a Hex plug in for Notepad++ and deleted the hidden characters.  Thanks Again!

Image 1.png