Qlik Community

QlikView Management

Discussion Board for collaboration on QlikView Management.

Not applicable

Converting Table Object into csv format

Hi,

I am trying to convert by my table object into csv format. I exported my table into csv format but when I open my csv file, the data is not being displayed in one line. Rather it looks like a table only even though the file is saved in .csv format. Dont know what's happening.

Please Help!

6 Replies

Re: Converting Table Object into csv format

where did you check, in excel? May be check in notepad or other editor tool
Not applicable

Re: Converting Table Object into csv format

duh...my bad.....thanks for the solution

hirishv7
Honored Contributor

Re: Converting Table Object into csv format

Hi,

Check this,

This may help you  Link,

makeuseof.com/tag/how-to-convert-delimited-text-files-into-excel-spreadsheets/

HTH,

Hirish

nagireddy_qv
Contributor II

Re: Converting Table Object into csv format

Hi Akash,

You will have to write a macro to achieve this.

sub ExportToCSV

set tb = ActiveDocument.GetSheetObject("TB99")
tb.Export "Final.csv",",",0

end sub

Where 0 = ANSI, 1200 =  Unicode, 65001 = UTF-8.  You might need ServerSideExport or ServerSideExportEx on a server.

Re: Converting Table Object into csv format

Can you close this thread, if you got the Answer..

MVP
MVP

Re: Converting Table Object into csv format

Hi,

If you open CSV file in Excel it will display in tabular format, if you really want to see the raw data open the csv file in any Notepad software.

Hope this helps you.

Regards,

jagan.

Community Browser