Change field in Table

[pascos88]

Hello everyone,

I have a problem.

From the name of a file, I generate the field of the table with SubField.

The name of file is

Pas_Gia_88.qvd

Table1:

Load

SubField(FileBaseName(),'_',1) as Name.

SubField(FileBaseName(),'_',2) as Surname.

SubField(FileBaseName(),'_',3) as Year.

from....

Table 1:

Name        Pas    

Surname   Gia

Year           88

My problem now is that I can't modify the name of the file, and I would like to have 89 for each 88.

My table should not have 88 in this file but 89.

Table 1:

Name        Pas    

Surname   Gia

Year           89

Thanks for any help

Pasquale

[pascos88]

Hi Jagan,

really thanks, but I need also :

if in a table already exist turbine name like T1, T2, T3, T4, the name not change..

With this ApplyMap('TurbineChange', turbine) AS turbine this appen?

Regards

Pasquale

[jagan]

Then try like this

TurbineChange:

LOAD

*

INLINE [

OldName, NewName

E1, T1

E2, T2

E3, T3

E4, T4];

Table1:

LOAD

farm,

ApplyMap('TurbineChange', turbine, turbine) AS turbine

FROM DataSourc;

Regards,

Jagan.