topic Change field in Table in QlikView

Change field in Table

pascos88 — Tue, 12 Jan 2016 08:36:20 GMT

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

Re: Change field in Table

PrashantSangle — Tue, 12 Jan 2016 08:39:43 GMT

Hi,

try

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

Regards

Re: Change field in Table

pascos88 — Tue, 12 Jan 2016 08:46:47 GMT

Hi Max thanks for the response.

But this was just an exeple, I need to change also other value that aren't not numeric value.

For example a different name.

Michael instead of Pas ..

Do you have some advice?

Regards

Pasquale

Re: Change field in Table

jagan — Tue, 12 Jan 2016 08:50:06 GMT

Hi,

Try like this using Mapping Load

YearChange:

MAPPING LOAD *

INLINE [

Year, NewValue

88, 89

100, 101];

Table1:

Load

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

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

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

from....

Hope this helps you.

Regards,

jagan.

Re: Change field in Table

pascos88 — Tue, 12 Jan 2016 08:51:49 GMT

The right exemple is this

Table1

farm turbine

A E1

B E2

C E4

C E2

I don't want name like E1, E2, E4, but different name like T1, T2, T4

Should be

Table1

farm turbine

A T1

B T2

C T4

C T2

E1,E2, E4 come from the name of the file and I can't change this

Regards

Pasquale

Re: Change field in Table

jonathandienst — Tue, 12 Jan 2016 08:52:42 GMT

You need to be more specific about what you need to change - preferably with a qvw file containing some representative a data and a clear explanation of the output you would like. You might need a mapping table to make these changes, but it is not possible to be more specific without a lot more information.

Edit - I see you have added some changes. What does this mean:

>>E1,E2, E4 come from the name of the file and I can't change this

Re: Change field in Table

pascos88 — Tue, 12 Jan 2016 08:56:24 GMT

The right exemple is this

Table1

farm turbine

A E1

B E2

C E4

C E2

I don't want name like E1, E2, E4, but different name like T1, T2, T4

Should be

Table1

farm turbine

A T1

B T2

C T4

C T2

E1,E2, E4 come from the name of the file and I can't change this

Regards

Pasquale

Re: Change field in Table

PrashantSangle — Tue, 12 Jan 2016 08:56:57 GMT

Hi,

In that case use MAPPING LOAD as suggested by Jagan.

Regards,

Re: Change field in Table

pascos88 — Tue, 12 Jan 2016 08:58:48 GMT

Hello Jagan,

thanks for response.

In Applymap('YearChange', SubField(FileBaseName(),'_',3)) as Year we don't need specify wich fild sholud be replace with another one?

Re: Change field in Table

jagan — Tue, 12 Jan 2016 09:03:05 GMT

Hi,

For changing turbine names try like below

TurbineChange:

LOAD

INLINE [

OldName, NewName

E1, T1

E2, T2

E3, T3

E4, T4];

Table1:

LOAD

farm,

ApplyMap('TurbineChange', turbine) AS turbine

FROM DataSourc;

Refer Qlikview help file for more details on this.

Regards,

jagan.

Re: Change field in Table

pascos88 — Tue, 12 Jan 2016 11:26:03 GMT

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

Re: Change field in Table

jagan — Wed, 13 Jan 2016 00:30:07 GMT

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.