Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

Qvd exclude column

How to exclude a column from the qvd?

rather columns....while reloading it into another .qvw

Any example is appreciated

4 Replies
Partner
Partner

Not sure I understood... what about this:

MyTable:

SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

STORE MyTable INTO myTable_qvd.qvd;

DROP MyTable;

//With this you reloaded only 2 columns...

MyTableReloaded:

LOAD field1, field3 from myTable_qvd.qvd

(qvd);

//...and if you want with this statement you overwrite the qvd

STORE MyTableReloaded INTO myTable_qvd.qvd;

S.

Creator
Creator

yeah..in this case i have to mention all the fields i want and remove the ones i dont want.

What if i have 35 fields and want to exclude one.

Do I have any other way than writing all 34?

Partner
Partner

You can do this lazy boy 🙂 :

MyTable:

SQL SELECT field1, field2, field3 from your_table; //or LOAD... it depends from where you are starting!

STORE MyTable INTO myTable_qvd.qvd;

DROP MyTable;

EXIT SCRIPT;

//so now you created .qvd.

//after this, you can use the button that allows you to open local files (something like tabellar files or table fields, I have no English version) and use the wizard. Then you have the entire list of files, so you can remove what don't you use.

//remember to remove or comment the EXIT SCRIPT

//With this you reloaded only 2 columns...

MyTableReloaded:

LOAD field1, field3 from myTable_qvd.qvd

(qvd);

//...and if you want with this statement you overwrite the qvd

STORE MyTableReloaded INTO myTable_qvd.qvd;


S.

MVP & Luminary
MVP & Luminary

LOAD * FROM x.qvd (qvd);

DROP FIELD FieldA, FieldG;

-Rob