topic Re: Remove Unnecessary Fields? Urgent in QlikView

Remove Unnecessary Fields? Urgent

Fri, 02 May 2014 09:03:25 GMT

HI All,

I Need to remove the Unnecessary fields which i haven't used in the application.

Can any one help me how to do that one.

Thanks,

Helen

Re: Remove Unnecessary Fields? Urgent

MK_QSL — Fri, 02 May 2014 09:17:21 GMT

Comment them in script. Something like below

Load

Field1,

// FIeld2, //Not used so comment

Field3

From .......

Re: Remove Unnecessary Fields? Urgent

ThornOfCrowns — Fri, 02 May 2014 09:17:52 GMT

The easiest way is to have a design document at the start and not to load them in the first place. Depending on the complexity of your load, data and dashboard design, doing it retrospectively may be a job from hell.

Re: Remove Unnecessary Fields? Urgent

Fri, 02 May 2014 10:04:36 GMT

I have commented the fields which are not used in the application.

I wanted to remove the fields which are not used in the front End..

Re: Remove Unnecessary Fields? Urgent

nirav_bhimani — Fri, 02 May 2014 10:09:08 GMT

http://community.qlik.com/ideas/2430

http://robwunderlich.com/downloads/

download DOCUMENT ANALYZER file.

Regards,

Nirav Bhimani

Re: Remove Unnecessary Fields? Urgent

MK_QSL — Fri, 02 May 2014 10:09:47 GMT

Any field not used or need to be used in future can be either commented out or your can use below in script

Drop Fields Field1, Field2 from TableName;

Drop Field from TableName;

If you will not mention From TableName, it will drop all existence the named field from the data model..

Re: Remove Unnecessary Fields? Urgent

Fri, 02 May 2014 10:10:38 GMT

in front end they can be deleted directly from object tab in sheet properties.

Re: Remove Unnecessary Fields? Urgent

ThornOfCrowns — Fri, 02 May 2014 10:47:28 GMT

I thought that Helen Betty was looking for a way to go back through the load to automagically remove any data field that's not used in the associated Dashboard(s), but the reply saying:

"I have commented the fields which are not used in the application.

I wanted to remove the fields which are not used in the front End."

has confused me mightily.

Re: Remove Unnecessary Fields? Urgent

ashishkalia — Fri, 02 May 2014 10:50:50 GMT

u jst need to right clik on the field not in use and clik remove....

Re: Remove Unnecessary Fields? Urgent

swuehl — Fri, 02 May 2014 10:51:44 GMT

Helen,

you can have a look at Rob's document analyzer, which helps you in identifying these fields.

Document Analyzer V1.15