unable to load in comma delimiter csv file correctly

[jim_chan]

Hi guys,

I have a comma delimiter csv file. after I have loaded in. Some of the data in columns not aligned, some shift 1 column to the left, some shifted 1 column to the right.

I have attached the .csv file.  i have use comma delimiter when loading in. but yet , still not able to get the data. how to solve it?

As I seelcted "2015" which are not suppose to be in column_full field, found out that the data in column_h has apostrophe( ' ) symbol.

But when i viewed in excel program, the rows and columns look fine.

why csv delimiter cannot handle special symbol like apostrophe (‘). ????

Jim

[maren_amthor]

I just tried and reloaded your skript and everything looks fine... (Using QV12 SR5)

[Anonymous]

Hi Jim,

Its working fine when I loaded the CSV from my end. Please see attached QlikView document. And also you may be getting this issue because of excel is promting a caution as shown in the attached image.

Thanks,

Sarat.K