topic Re: QlikView beginner CSV in QlikView

QlikView beginner CSV

Fri, 20 Nov 2020 18:02:30 GMT

Hi everyone,

I am a programmer and developer with a good experience in various programming languages and SQL.

I am exploring the QlikView and am a beginner in this new BI tool. My company recently purchased 4 licenses of QlikView. Hoping that I can get the good support from this community.

Recently have problems importing data from .CSV format and trying to resolve in my recent project.

Chickov.

Re: QlikView beginner CSV

Thu, 29 May 2014 12:54:40 GMT

http://www.citagus.com/citagus/blog/different-ways-to-load-data-in-to-qlikview/

I am not sure what your problem with your csv is, but this link contains some general info. Also referencing the qlikview user manual may help you with your issue.

Re: QlikView beginner CSV

its_anandrjs — Thu, 29 May 2014 12:56:15 GMT

What problem you are facing the format issue or any thing else.

Re: QlikView beginner CSV

Thu, 29 May 2014 13:09:13 GMT

Can you just save your csv as an excel file and import that instead?

Re: QlikView beginner CSV

Thu, 29 May 2014 13:11:25 GMT

Is the issue you are facing data formatting? Or some other issue?

Re: QlikView beginner CSV

Thu, 29 May 2014 13:26:15 GMT

QlikView is treating the delimited ex.: "0.000" values of the ".CSV" comma separated values differently against different cases and conditions like "0.000", "NULL" values and (" ").

See the image below:

Thanks people for your urgent attention to my problem...

Re: QlikView beginner CSV

Thu, 29 May 2014 13:28:40 GMT

@rdaitzman

@ its.anandrjs

Look at the format below.

Re: QlikView beginner CSV

Thu, 29 May 2014 13:33:41 GMT

I'm not sure I understand what you're trying to say. Could you share what you're working with and maybe it'll be more obvious?

Re: QlikView beginner CSV

Thu, 29 May 2014 13:39:43 GMT

I am working with the large database of PostgreSQL, and I am exporting all the data through SQL query into CSV format and then working on the data in QlikView.

Because while making direct connection with the Postgre it takes a lot of time to process the data while importing directly from the .csv format is much more time-efficient as compared to the any kind of odbc or any other DB connections.

I hope you understand my problems now as it have a data in millions of rows and 100s of columns.

Thanks for your reply.

Re: QlikView beginner CSV

Thu, 29 May 2014 13:41:12 GMT

Look at the format below.

Re: QlikView beginner CSV

Thu, 29 May 2014 13:47:19 GMT

I don't know exactly what problem you are facing with.

From your post it seems like a limitation on a data size in a text file.

Or it is formating issue (decimal separator, tausend separator, delimiter, code page...)?

Re: QlikView beginner CSV

Thu, 29 May 2014 13:48:12 GMT

" is your text indicator ; is your separator can you copy your load script here so we can check the syntax?

Re: QlikView beginner CSV

its_anandrjs — Thu, 29 May 2014 13:54:23 GMT

If there is problem in data loading then use the functions like Subfield, Mid, Left, Right, Keepchar, PurgeChar if data in single field or more field then transform this data in the load script to get perfect data.

Regards

Re: QlikView beginner CSV

Thu, 05 Jun 2014 15:35:23 GMT

I am still resolving this problems, but subfield helped me solve other problems with my data. As my data is in millions of rows is cause of root of all the problems.

Re: QlikView beginner CSV

Mon, 11 Aug 2014 13:41:15 GMT

can you copy your load script here so we can check the syntax?

Re: QlikView beginner CSV

rustyfishbones — Mon, 11 Aug 2014 13:46:58 GMT

can you share the .csv file?