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

[giakoum]

with the sample data it works as expected I believe :

LOAD id,

     item_id,

     column_d,

     column_e,

     column_f,

     column_g,

     column_h,

     column_i,

     column_j,

     column_l,

     column_m,

     column_n,

     column_o,

     column_p,

     column_year,

     column_full,

     column_num,

     column_t,

     column_u,

     column_v

FROM

(txt, codepage is 932, embedded labels, delimiter is ',', msq);

[dmac1971]

Agree worked fine in my tests, unless we are missing something?

[giakoum]

I guess we are

let's wait for Jim and see

[jim_chan]

Hi there.

I wasnt able to get your expected result . here is my test.qvw , can you hav a look?

i am using qlikview 12.

[robert_mika]

is working for me:

LOAD id, item_id, column_d, column_e, column_f, column_g, column_h, column_i, column_j, column_l,

     column_m, column_n, column_o, column_p, column_year, column_full, column_num, column_t,

     column_u, column_v

FROM

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

[sunny_talwar]

It actually did not work for me as well when I tried doing this

Script

Table:

LOAD id,

     item_id,

     column_d,

     column_e,

     column_f,

     column_g,

     column_h,

     column_i,

     column_j,

     column_l,

     column_m,

     column_n,

     column_o,

     column_p,

     column_year,

     column_full,

     column_num,

     column_t,

     column_u,

     column_v

FROM

test.csv

(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Output

[jim_chan]

yeaaaah.. i really surprised how some of the guys able to do it.

Anyway bro, i have attached my sample.qvw - with issue

[jim_chan]

i have attached my sample.qvw . i coudltn get it right.

[jim_chan]

I have downloaded ur qvw and I loaded in the test.csv file again. but i got this result..

r u using qlikview 12?