topic Drop not used field! in QlikView

Drop not used field!

brunolelli87 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Drop not used field!

rwunderlich — Thu, 04 Jun 2020 20:06:38 GMT

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

Re: Drop not used field!

brunolelli87 — Thu, 04 Jun 2020 20:42:56 GMT

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

Re: Drop not used field!

Brett_Bleess — Wed, 01 Jul 2020 12:11:44 GMT

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