loading csv file

[arulsettu]

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 ?

[alexandros17 · Accepted solution]

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

[ashwanin]

Yes, its necessary.

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

[arulsettu]

what is 1252 and msq

[alexandros17]

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

[arulsettu]

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

[alexandros17]

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

[ashwanin]

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

[arulsettu]

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

[alexandros17]

Could you mark the answer if it has been helpful?

Thankyou