topic Re: loading csv file in QlikView

loading csv file

arulsettu — Fri, 24 Jan 2014 10:22:36 GMT

HI..

while loading csv file in script what is the use of this code

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

is this necessary ?

Re: loading csv file

alexandros17 — Fri, 24 Jan 2014 10:25:54 GMT

Absolutely yes,

it is the code automatically provided when you load tabellar files, it says you are loading a txt with a particular codepage, with labels as headers of columns, the delimiter betrween columns is comma

Hope it helps

Re: loading csv file

ashwanin — Fri, 24 Jan 2014 10:29:26 GMT

Yes, its necessary.

Actually its the recommended coding to link the CSV file with QlikView application.

Re: loading csv file

arulsettu — Fri, 24 Jan 2014 10:49:12 GMT

what is 1252 and msq

Re: loading csv file

alexandros17 — Fri, 24 Jan 2014 10:57:19 GMT

codepage is the set of characters, while msq is the kind of quotes user in the document

Re: loading csv file

arulsettu — Fri, 24 Jan 2014 11:01:41 GMT

what about other db like mysql or sql we have to mention anything like this?

Re: loading csv file

alexandros17 — Fri, 24 Jan 2014 11:09:46 GMT

The definition is automatically composed by Qlik, if you use the wizard you are guided.

Use help to learn all the types

Hope it helps

Re: loading csv file

ashwanin — Fri, 24 Jan 2014 11:25:49 GMT

Alessandro is right, open QV and do the loading of all type.

You can also get to know about all types from below.

http://community.qlik.com/docs/DOC-5698

Re: loading csv file

arulsettu — Fri, 24 Jan 2014 11:35:58 GMT

thank you all clearing this...........

Re: loading csv file

alexandros17 — Fri, 24 Jan 2014 11:38:15 GMT

Could you mark the answer if it has been helpful?

Thankyou