topic Is there a text tool for searching multiple QVW scripts ? in QlikView

Is there a text tool for searching multiple QVW scripts ?

Wed, 14 Oct 2015 15:09:22 GMT

Hi Experts,

I have many QlikView applications, each with multiple script tabs, across a number of Windows folders.

I want to change the name of a field held on a QVD. However, the impact of this will be vast as the field is used in numerous scripts across the system in .qvw and .scp files

Is there a QlikView tool or accessory I can use to identify the field name without manually trawling through every file.

Thanks in advance

Re: Is there a text tool for searching multiple QVW scripts ?

jonas_rezende — Thu, 15 Oct 2015 02:15:28 GMT

Hi, Maureen Vickers.

The script load the file for consume. So, the name field should be exactly equal the file.

The could minimize of effort in alter name on scripts of each qvw will be:

Just change the name in reading puller and keeps the QVD.

Before in Extractor.qvw

Table1:

Load

field1,

field2,

field3

from [<nametable>];

Store [Table1] INTO [..\qvd\Table1.qvd] (qvd);

After in Extractor.qvw

Imagine that field3 was replaced for finance name.

Table1:

Load

field1,

field2,

finance as field3

from [<nametable>];

Store [Table1] INTO [..\qvd\Table1.qvd] (qvd);

Thus, do not worry about hitting the other qvw's. Obsviouly, if haven't load incremental.

Hope this helps!

Re: Is there a text tool for searching multiple QVW scripts ?

Thu, 15 Oct 2015 06:52:46 GMT

Hi Jonas,

I see what you are doing but it doesn't really answer my question. Rather than renaming the field everytime it's loaded in a dashboard it would be better to name the field as it is on the QVD.

Anyone else ? Do QVD fields never get renamed ?

All opinions welcome.

Re: Is there a text tool for searching multiple QVW scripts ?

jonas_rezende — Thu, 15 Oct 2015 22:28:43 GMT

Hi.

Once rename and save, always will appear in qvd.

If I understand, you make reload of the qvd existing in one qvw different and rename the field. After, save overwriting <filename>.qvd.

Hope this helps!