topic Re: Creating a table from a CSV file in QlikView

Creating a table from a CSV file

Wed, 20 Jun 2012 13:11:26 GMT

Hi,

How do I go about creating a table from a CSV file?

Reading data from excel easily enables me to identify the table name from the worksheet name. However, for CSV or txt files it's not so obvious.

Thanks.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:18:25 GMT

Hi,

Can u Attach the CSV file for which u r getting problem.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:28:56 GMT

Hi Pratibha,

I have no issues in uploading the CSV file to QlikView. However, I want to create a table so I can store this data in a QVD.

I have multiple CSV files to feed into the QVD and my code is set up like this:

For each vFileName in FileList ('C:\My Documents\Data\*.csv')

Directory;

LOAD

.....

FROM [$(vFileName)] (txt, codepage is 1252, embedded labels, delimiter is ',', msq);

STORE tablename$ INTO C:\My Documents\Data\DB.qvd;

DROP TABLE tablename$

However, the tablename$ doesn't appear when I load the data in like an excel spreadsheet. How do I go about storing each CSV file into a single QVD file?

Thanks.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:29:54 GMT

Hi rkapadia16,

its very easy to create teables or whatever you want to create using csv ot txt files. when loading data just select from the file type delimited and then whater delimeter you are using in your csv you can select with embeded rows or whatever you want..hope it will guide you to the right direction.

Best,

Sam

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:31:22 GMT

store into C:\My Documents\Data\DB.qvd(qvd);

just add (qvd) like above.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:33:46 GMT

the right syntax would be...

store * from tablename$ into C:\My Documents\Data\DB.qvd(qvd);

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:37:36 GMT

How do I assign this to a table? It's because in the loading script it doesn't tell me what the table name is.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:41:33 GMT

you can yourself assign table name...lets say you are creating a table name called Customer so on the script level you can do it like this..

Customer :

Load feild1, feild2,...

from data.xlx;

store * from Customer into Customer.qvd(qvd);

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:50:25 GMT

Thanks Salman.

This works now.

Re: Creating a table from a CSV file

Wed, 20 Jun 2012 13:58:51 GMT

Bitte schön:)