Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export to csv issue

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.

14 Replies
quwok
Creator III
Creator III

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.


sasiparupudi1
Master III
Master III

can you post a sample of your data

sasiparupudi1
Master III
Master III

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.

Untitled.jpg

hth

Sasi

Not applicable
Author

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.

sasiparupudi1
Master III
Master III

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

Sasi