topic Re: Export to csv issue in QlikView

Export to csv issue

Thu, 03 Sep 2015 06:45:51 GMT

dear all,

when i export data from Qlikview application to abc.csv its remove zero or zero's from the start of text or number type columns for example,

value is 0123456 its show in csv 123456 or 001234 its show 1234 or 0001234 its how 1234.

kindly guide how to resolve this.

Regards,

Zain.

Re: Export to csv issue

jerrysvensson — Thu, 03 Sep 2015 07:41:40 GMT

Try this:

text(field) as field

in your script.

QlikView interprets the data as number and will remove the 0.

Re: Export to csv issue

Thu, 03 Sep 2015 08:00:24 GMT

Dear, did before post but found no change.

Regards,

Zain.

Re: Export to csv issue

sasiparupudi1 — Thu, 03 Sep 2015 09:37:14 GMT

can you post a sample please?

Re: Export to csv issue

quwok — Thu, 03 Sep 2015 09:41:21 GMT

Did you open your file in Excel? Have you check how the data looks like in a standard text editor such as Notepad?

Re: Export to csv issue

Thu, 03 Sep 2015 09:47:03 GMT

Yes, and working fine.

issue is i have large amount of data to export, due to this QV goes to export data to csv format automaicly and its exclude leading zeros.

Regards,

Zain.

Re: Export to csv issue

quwok — Thu, 03 Sep 2015 10:16:14 GMT

I wasn't referring to exporting as Excel, but once you have the csv file, did you tried opening it in Notepad and verify the output that way?

Re: Export to csv issue

qlikviewwizard — Thu, 03 Sep 2015 10:35:03 GMT

Hi,

Use this in scrit:

text(field) as field

It is better to upload the qvw with sample data to demonstrate your requirement. Thank you.

Re: Export to csv issue

Thu, 03 Sep 2015 11:25:03 GMT

Yes checked new mins ago and found data is perfect, also export data into access and got result fine.

but why excel is excluding leading zeros, kindly reply if you know that.

Thanks Kwok Chong for time and replies.

Regards,

Zain.

Re: Export to csv issue

ganeshreddy — Thu, 03 Sep 2015 11:38:45 GMT

Hi Zain,

Try this

repeat('0',7-len(Field))&[Field] as [New Field],

Regards,

Ganesh

Re: Export to csv issue

quwok — Thu, 03 Sep 2015 11:45:38 GMT

Excel is being intelligent and identified the column as number and hence formatted it as a number which drops preceding zeros.

The same thing happens in QlikView, hence the use of text() to force the data type on the field.

Re: Export to csv issue

sasiparupudi1 — Thu, 03 Sep 2015 12:23:47 GMT

can you post a sample of your data

Re: Export to csv issue

sasiparupudi1 — Thu, 03 Sep 2015 12:39:20 GMT

Instead of double clicking on the csv file to open in excel, do the following

open excel

go to data tab, select from text file option

manually specify the delimeter

and change the number column to text.

hth

Sasi

Re: Export to csv issue

Thu, 03 Sep 2015 13:00:25 GMT

Thanks dear Sasidar for time and replies, i have got it results, i did export to csv and fetch data into access and also data in excel.

Regards,

Zain.

Re: Export to csv issue

sasiparupudi1 — Thu, 03 Sep 2015 13:04:46 GMT

Great, please close this thread by marking your resolution, thanks

Sasi