topic Re: Renaming Multiple fields in Qlikview Script in QlikView

Renaming Multiple fields in Qlikview Script

riyazasma1009 — Tue, 10 Jan 2017 05:43:40 GMT

Hi All,

I am loading the below fields in the load script editor:

I wish to rename fields A,B,C to Test.

Can anyone please help me with the same.

Thanks,

Asma

Re: Renaming Multiple fields in Qlikview Script

Anonymous — Tue, 10 Jan 2017 05:54:34 GMT

Hi,

Your field names will have to be unique for each table.

Unless you concatenate fields A B & C together and rename as Test.

If they do not belong to the same table:

rename Field A to Test;

or you can use mapname to rename multiple fields - See qlikview help file

If i have not understood your requirement fully please provide further details.

Thanks

Re: Renaming Multiple fields in Qlikview Script

petter — Tue, 10 Jan 2017 09:16:28 GMT

If you need to get the sum of the three fields into one field without tracking where the individual values came from you could simply do:

LOAD

A + B + C AS Test1, // If they are numbers

A & ',' & B & ',' & C AS Test2, // If they are strings

FROM

......;

OR if you need to keep track of the origin field you could use the CROSSTABLE prefix:

CROSSTABLE( OrgField, Test, 2) LOAD

FROM

....;

You will then get a resulting table of:

D, E, A, OrgField, Test

with 3x as many rows as the source but in the OrgField you will have a value of A, B or C depending on which field the value came from.

Re: Renaming Multiple fields in Qlikview Script

avinashelite — Tue, 10 Jan 2017 10:20:25 GMT

If A,B and C columns are from the same table then you cannot have the same field name for all the 3 fields , that's not allowed ..if its from the different table then try like

rename Field A to Test;

rename Field B to Test;

rename Field C to Test;

check this thread

How to Rename Fields

How to rename a field in qlikview