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?
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().
Thanks that seemed to do the trick. I d/l a Hex plug in for Notepad++ and deleted the hidden characters. Thanks Again!
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
This is what it looks like in the Wizard.
Are you able to share the csv with us (only first few rows needed)?
Retrieving data ...