Remove Unnecessary Fields? Urgent

[#1]

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

[MK_QSL]

Comment them in script. Something like below

Load

     Field1,

//     FIeld2, //Not used so comment

     Field3

From .......

[ThornOfCrowns]

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.

[#4]

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..

[nirav_bhimani]

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

or

http://robwunderlich.com/downloads/

download DOCUMENT ANALYZER  file.

Regards,

Nirav Bhimani

[MK_QSL]

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;

or

Drop Field from TableName;

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

[#7]

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

[ThornOfCrowns]

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.

[ashishkalia]

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

[swuehl · Accepted solution]

Helen,

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

Document Analyzer V1.15