topic Re: Rename field with data from another field in QlikView

Rename field with data from another field

Tue, 03 Dec 2013 10:18:49 GMT

I´m stucked on how to rename a field by using data (text) from fields in a diffrent table.

In table 'VUXSFI' I have the EGET1, EGET2, EGET3 and EGET4

In table 'EGENDEF' I have TEXT and NUMMER

There are no connection between them more then that I know that EGET1 has the value in TEXT corresponding to NUMMER A as header in the program.

EGET1 should therfore be renamed by using the text in 'EGENDEF' from field TEXT corresponding to value A in NUMMER

EGET1 = V13 (A)

EGET2 = V11 (B)

Re: Rename field with data from another field

Tue, 03 Dec 2013 11:00:41 GMT

I do not fully understand. But you did not try to load with the type NUM(A) as EGET1

Load:

num(A) as EGET1

text(B) as EGET2

...

Re: Rename field with data from another field

Tue, 03 Dec 2013 11:15:44 GMT

Yes, If I do that I assaign the value and don´t rename the field.

The problem is that I want the field EGET1 to be renamed to the value in TEXT that are connected to A in field NUMMER

In the pictures I have selected a personID that in EGET1 has the value of 83.

In EGET2 = 146 and EGET3 = 6, EGET4 null

Insted of EGET1 the field should be named to V13 and still have the values stored in it.

EGET2 should be renamed to V11, EGET3 to H11 and EGET4 to HT12

The are no connections between the tables.

Re: Rename field with data from another field

Tue, 03 Dec 2013 11:38:03 GMT

oh. now understood. try

Table1:

load:...

EGET1 ,

'V13' as TEXT

...

from ...(qvd);

concatenate Table1:

load:

...

EGET2 ,

'V11' as TEXT

...

from ...(qvd);

ETC.

Load:

number,

TEXT

From ...(qvd)

Re: Re: Rename field with data from another field

Tue, 03 Dec 2013 11:42:52 GMT

Yes. That´s close to what I want but the values in TEXT will change yearly = I don´t want to change it manually but read the value from the TEXT in table egendef

edit. strange. the qvd:s have xml. remove that when you open

Re: Rename field with data from another field

Tue, 03 Dec 2013 12:02:44 GMT

can see only tomorow. But uoy can use :

LOAD

RowNo() as ID,

NUMMER,

TEXT

FROM

(qvd);

//set q=;// in set must write max(ID)

for i=1 to 4 //q

Concatenate

TAble_test:

LOAD [AutoNumber(PERSONID)],

'EGET'&$(i) , //there need write EGET$(i) , but now not have time

$(i)

FROM

(qvd);

Re: Re: Re: Rename field with data from another field

Wed, 04 Dec 2013 04:57:12 GMT

Hi!

it for you

.rar with qvw

Re: Re: Re: Rename field with data from another field

Wed, 04 Dec 2013 06:48:58 GMT

A brilliant solution, you are my hero for the day!