topic Re: How to export a straight table in excel? in QlikView

How to export a straight table in excel?

Mattia — Sat, 16 Nov 2024 02:02:17 GMT

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

Re: How to export a straight table in excel?

jaibau1993 — Tue, 05 Nov 2019 14:29:42 GMT

Hi!

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

Re: How to export a straight table in excel?

Mattia — Tue, 05 Nov 2019 14:32:09 GMT

Hi,

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

Do you have any suggest?

Thanks,

Mattia

Re: How to export a straight table in excel?

jaibau1993 — Tue, 05 Nov 2019 14:36:47 GMT

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.

Re: How to export a straight table in excel?

Mattia — Thu, 07 Nov 2019 15:13:16 GMT

Hi Jaime,

thanks for the suggest.

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

I'll let you know.

Mattia