Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Mattia
Creator II
Creator II

How to export a straight table in excel?

Spoiler
Hi guys,

i need to export a straight table in excel, but it have a lot of rows (about 500k) and 20 columns.

I've tried with "export" or "send to excel" but the process is too long and the sw don't work.

How can i optimize this operation?

Thanks,

Mattia
Labels (3)
4 Replies
jaibau1993
Partner - Creator III
Partner - Creator III

Hi!

You can try to do it in the script side if possible. Elsewise... I'd think you'll have to wait!

Mattia
Creator II
Creator II
Author

Hi,

in the script side what is the right expression to do this?

Do you have any suggest?

Thanks,

Mattia

jaibau1993
Partner - Creator III
Partner - Creator III

You can save script tables in QVD or TXT format. Said so, you have to write something like

TableToSave:
Load
    Field1
    Field2
    ...
resident [YourSourceTable];

Store TableToSave into ./TableToSave.csv (txt);
Drop Table TableToSave;

Note that you may need to perform some joins to pick all needed fields in one table.

regards,

Jaime.

Mattia
Creator II
Creator II
Author

Hi Jaime,

thanks for the suggest.

I've tried to export the table in txt format.

I'll let you know.

 Mattia