Drop not used field!

[brunolelli87]

Hello folks,

Is there any way to find and drop those unused fields?

I know we can use the Drop Table to drop the unnecessary Tables, but can we do the same thing with fields?
And also, is there any way to find the fields you have in your file that are now being used?

Thanks,
Bruno 

[rwunderlich]

You can use

Qlikview Cookbook: QV Document Analyzer http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

to identify the unused fields and generate a DROP FIELDS statement. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com

[brunolelli87]

Thanks, Rob,

I downloaded but once it's a QlikView file I'm using a Personal Edition of QlikView I can't open it!

It's sad, but I understand

Thanks

[Brett_Bleess]

Here is a Design Blog post that may be of further help in addition to Rob's comments:

https://community.qlik.com/t5/Qlik-Design-Blog/Drop-Field-and-Drop-Table/ba-p/1465697

Regards,
Brett