topic Re: Change field name and values in QlikView

Change field name and values

Anonymous — Tue, 09 Oct 2012 11:55:56 GMT

I have the field PharmacyName that I want to change to PharmacyDemo as follows.

PharmacyName change to PharmacyDemo

PharmacyA change to Pharmacy1

PharmacyB change to Pharmacy2

PharmacyC change to Pharmacy3

PharmacyName is a field that already exists in the model.

PharmacyDemo does not exist in the model

How can I do this?

Re: Change field name and values

Gysbert_Wassenaar — Tue, 09 Oct 2012 11:57:02 GMT

See here: http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/25/how-to-rename-fields

Re: Change field name and values

Anonymous — Tue, 09 Oct 2012 12:55:26 GMT

so I have this in my script

DemoMapping:

Mapping LOAD PharmacyName, PharmacyDemo

FROM

(ooxml, embedded labels, table is Sheet1);

Rename Fields using DemoMapping;

but it's not working.

I have the listbox with PharmacyName on each sheet of my QlikView Model,

on the first sheet, it changes PharmacyName to PharmacyDemo, but says the field is unavailable.

On all the other sheets PharmacyName has not change to PharmacyDemo

Re: Change field name and values

Gysbert_Wassenaar — Tue, 09 Oct 2012 13:02:58 GMT

Try this:

DemoData:

LOAD *

FROM

(ooxml, embedded labels, table is Sheet1);

DemoMapping:

Mapping LOAD * inline [

OldName, NewName

PharmacyName, PharmacyDemo

PharmacyA, Pharmacy1

PharmacyB, Pharmacy2

PharmacyC, Pharmacy3

];

Rename Fields using DemoMapping;

In this case I used and inline table, but if you have a lot of fields it's easier to maintain it in a seperate text or excel file as in Henric's blog post.

Re: Change field name and values

jagan — Tue, 09 Oct 2012 15:42:23 GMT

Hi,

If you are renaming only one field then instead of Mapping load you can straight away rename it by using

Rename field OldFieldName to NewFieldName;

Regards,

Jagan.

Re: Change field name and values

leonchoo — Tue, 22 Jan 2019 08:54:23 GMT

Hi there,

I find your method really useful! however, what if the field value that I am changing has a comma in it?

e.g. Fieldvalue 1 is Marketing, Branding and Analytics which I want to change to Fieldvalue 2 which is Marketing, Analytics?

Looking forward to your reply and thanks!

Re: Change field name and values

leonchoo — Tue, 22 Jan 2019 08:55:54 GMT

Hi there,

I find your method really useful! however, what if the field value that I am changing has a comma in it?

e.g. Fieldvalue 1 is Marketing, Branding and Analytics which I want to change to Fieldvalue 2 which is Marketing, Analytics

Looking forward to your reply and thanks!