Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Partner
Partner

How to find unused columns in DataModel . . .

Hi All,

I am having a huge datamodel. For optimazation purpose, I want to remove all the un-necessary fields in datamodel. Is there any tool/ utility or simple way available to find out columns which are not being used but are getting fetch during reload . . .

Thanks & Regards,

Prasad D. Dumbre

1 Solution

Accepted Solutions
Partner
Partner

Re: How to find unused columns in DataModel . . .

http://robwunderlich.com/downloads/

Hi All, This link provides answer to my query . . .

View solution in original post

5 Replies
Partner
Partner

Re: How to find unused columns in DataModel . . .

http://robwunderlich.com/downloads/

Hi All, This link provides answer to my query . . .

View solution in original post

Employee
Employee

Re: How to find unused columns in DataModel . . .

Hi Prasad,

Check out the document analyser on Rob Wunderlich's blog:

HTTP://robwunderlich.com/downloads

This allows you to analyse an application for unused fields amongst other things.


Regards,


Clint Carr

sundarakumar
Valued Contributor II

Re: How to find unused columns in DataModel . . .

 

http://robwunderlich.com/downloads/

An automated tool that can help you spot unused files is Rob Wunderlich's

Document Analyzer. This QlikView document is used to process another QlikView

document and indicate which fields are not being used anywhere in the layout

or expressions.

sundarakumar
Valued Contributor II

Re: How to find unused columns in DataModel . . .

The link is beeing moderated for now, you will be getting it soon...

PFB

http://robwunderlich.com/downlaods

-Sundar

sujeetsingh
Honored Contributor III

Re: How to find unused columns in DataModel . . .