Is there a text tool for searching multiple QVW scripts ?

[#1]

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

MV

[jonas_rezende]

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!

[#3]

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.

[jonas_rezende]

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!