topic Re: unable to load in comma delimiter csv file correctly in QlikView

unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:19:01 GMT

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

Re: unable to load in comma delimiter csv file correctly

giakoum — Tue, 27 Sep 2016 09:25:02 GMT

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);

Re: unable to load in comma delimiter csv file correctly

dmac1971 — Tue, 27 Sep 2016 09:26:32 GMT

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

Re: unable to load in comma delimiter csv file correctly

giakoum — Tue, 27 Sep 2016 09:31:15 GMT

I guess we are

let's wait for Jim and see

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:31:21 GMT

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.

Re: unable to load in comma delimiter csv file correctly

robert_mika — Tue, 27 Sep 2016 09:31:21 GMT

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);

Re: unable to load in comma delimiter csv file correctly

sunny_talwar — Tue, 27 Sep 2016 09:32:49 GMT

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

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:34:06 GMT

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

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

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:35:02 GMT

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

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:37:25 GMT

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

r u using qlikview 12?

Re: unable to load in comma delimiter csv file correctly

giakoum — Tue, 27 Sep 2016 09:40:50 GMT

Sorry I have only QV1120 SR12

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:43:54 GMT

sunny,

which qv version r u using rite now?

Rgds

Jim

Re: unable to load in comma delimiter csv file correctly

puttemans — Tue, 27 Sep 2016 09:44:18 GMT

Tried here as well, everything came out just fine. I'm using Version 11.2 SR12

Re: unable to load in comma delimiter csv file correctly

sunny_talwar — Tue, 27 Sep 2016 09:44:40 GMT

QV12 SR5

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:45:13 GMT

i have tested on qv 1120 as well from my colleague. seems like is version issue .

its working fine on qlikview 1120, but not on version qlikview 12...... i am using qlikview 12!

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 09:47:18 GMT

thanks for testing! now i need someone whois using qv 12 to tell me !

Re: unable to load in comma delimiter csv file correctly

robert_mika — Tue, 27 Sep 2016 10:01:09 GMT

Yes 12.10

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 10:04:25 GMT

Hello Robert,

which SR r u using.?? i am using qlikview 12 sr5.

Re: unable to load in comma delimiter csv file correctly

robert_mika — Tue, 27 Sep 2016 10:04:27 GMT

Change

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

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

Re: unable to load in comma delimiter csv file correctly

jim_chan — Tue, 27 Sep 2016 10:08:47 GMT

Hello Mika,

i have downgraded to 11.20 sr15. and i have no problem loading ur qvw file and csv file.. all working fine under qv 11.20sr 15.

Can you let me know which qv 12 sr you are using? i am using SR 5, which i faced the issue.