topic Re: Rename data in field in QlikView

Rename data in field

Supertendi — Wed, 16 Sep 2020 13:30:34 GMT

Hi everyone,

I have some data in one field called "Ires" and "Irap" and i want to change their name in "Imposte". the field is named "DESC_GRP".

this is my script that doesn't work

Tabella_riclassificato:
LOAD DESC_GRP,
If(DESC_GRP='Ires','Imposte',IF(DESC_GRP='Irap','Imposte',DESC_GRP)) AS DESC_GRP;

SQL SELECT IND, TIPO, CODICE, DESCRIZIONE, SUBTOTALI, GRUPPO, CDC_SBT, DESC_GRP, CONTO_RICLASSIFICATO
FROM GIMETAL_RICLASSIFICATO

any idea?

THANKS

Re: Rename data in field

Taoufiq_Zarra — Wed, 16 Sep 2020 13:46:42 GMT

@Supertendi

to rename fialed use

Rename Field XXX to YYYY;

and if I understtod correctly

LOAD *, If(DESC_GRP='Ires','Imposte',IF(DESC_GRP='Irap','Imposte',DESC_GRP)) AS DESC_GRP; SQL SELECT IND, TIPO, CODICE, DESCRIZIONE, SUBTOTALI, GRUPPO, CDC_SBT, DESC_GRP, CONTO_RICLASSIFICATO FROM GIMETAL_RICLASSIFICATO

Re: Rename data in field

edwin — Wed, 16 Sep 2020 14:02:10 GMT

Your post title is a little bit misleading. what you really wanted was transform your data. the if statement in your script is correct. however, the problem is that you are naming the transformed field the same as an existing field. QV will not allow the same field name used more than once. how about:

Tabella_riclassificato:
LOAD DESC_GRP,
If(DESC_GRP='Ires','Imposte',IF(DESC_GRP='Irap','Imposte',DESC_GRP)) AS DESC_GRP_TRANSFORMED;

....

Re: Rename data in field

Supertendi — Wed, 16 Sep 2020 14:04:25 GMT

I would like to maintain the same name because I have several expressions working with this field name.

Re: Rename data in field

Kushal_Chawda — Wed, 16 Sep 2020 15:06:31 GMT

@Supertendi You could write match function as well to simplify . Also try to use trim with lower function to make sure that it should written value when there is white spaces or case mistamtch

LOAD *, If(match(lower(trim(DESC_GRP)),'ires','irap'),'Imposte',DESC_GRP)) AS DESC_GRP; SQL SELECT IND, TIPO, CODICE, DESCRIZIONE, SUBTOTALI, GRUPPO, CDC_SBT, DESC_GRP, CONTO_RICLASSIFICATO FROM GIMETAL_RICLASSIFICATO;

Re: Rename data in field

edwin — Wed, 16 Sep 2020 17:11:48 GMT

you cant have the same field name twice in same table. you can switch the field names if you want:

Tabella_riclassificato:
LOAD DESC_GRP as SOMEOTHERNAME,
If(DESC_GRP='Ires','Imposte',IF(DESC_GRP='Irap','Imposte',DESC_GRP)) AS DESC_GRP;

Re: Rename data in field

edwin — Wed, 16 Sep 2020 17:12:40 GMT

this will fail as DESC_GRP will appear twice

Re: Rename data in field

Supertendi — Thu, 24 Sep 2020 12:43:01 GMT

Hi,

it says syntax error: FROM missing or misplaced...

Re: Rename data in field

Chanty4u — Sat, 10 Oct 2020 15:36:59 GMT