topic Mapping field name in QlikView

Mapping field name

jvitantonio — Wed, 23 Nov 2011 09:39:23 GMT

Hi,

I created an application with standard DB field names. Then I change them using the mapping fuctions but I noticed that formulas and stuff don't get updated.

Is there any way to map the field names and not change all the filds in the application manually? For requirement reasons, one fild today can be called in a one and tomorrow in a different way and I cannot be change the formulas every time I change a field name.

Any thoughts?

Re: Mapping field name

Wed, 23 Nov 2011 10:56:05 GMT

you can manage in an excel file (for example) the technical name and friendly name .

then in you application use this kind of code at the end of the load script :

Mapping_xls :

Mapping LOAD TECH_NAME, DISP_NAME FROM [..\Sources\mapping field.xls] (biff, embedded labels, table is Sheet1$);

Rename fields using Mapping_xls;

when a field name changes, you will have to update your excel file and simply reload your application.

hope this helps

Gilles

Mapping field name

jvitantonio — Wed, 23 Nov 2011 11:28:32 GMT

Gilles, this does not answer my question. This is not what Im asking. I've already changed the names but what I need is a way NOT TO change ALL the formulas in my application and put the new field name instead of the old one.

Mapping field name

Wed, 23 Nov 2011 12:50:38 GMT

Sorry for confusion. Anyway my suggested solution can help for future changes if you decide to use the friendly name in your formulas.

Another way you can investigate (i have not checked myself) :

Open Settings menu, then Expression overview. there is a find/replace button.

May it help ?

Regards

Gilles

Mapping field name

jvitantonio — Wed, 23 Nov 2011 13:17:40 GMT

Gilles, Thanks again. Now this have more sense. I've tried this and it worked although it's not 100% convinient! Thanks for your time!