topic Is there a Field caption in V9 ? in QlikView

Is there a Field caption in V9 ?

Thu, 05 Nov 2009 20:20:14 GMT

Hi,

when you load data from some datawarehouse, you may see very user-friendly (irony) field name like "FR_EXT_EU_345643_SD" or other things like this. So 1) you are forced to make big changes of all loaded field or 2) you use the original names, but then , you can use labels in interface but the selections boxes uses original names 😞

Several months ago, someone tolds me V9 would include a functionality to include a field 'caption". That is to say a "second" name of the field in order to solve this problem.

I haven't seen it yet , is this functionality exits in QlikView V9 today ? Or is there workaround techniques ?

Best regards

Is there a Field caption in V9 ?

Thu, 05 Nov 2009 20:48:15 GMT

Hi,

It doesn't seem to be resolved in V9. 😞

Best regards,

Janusz

Is there a Field caption in V9 ?

Thu, 05 Nov 2009 23:34:19 GMT

Yes but, is that official ?

Is there a Field caption in V9 ?

Thu, 05 Nov 2009 23:54:20 GMT

As a workaround, you can create a mapping table such as Old field name, New field name.

Then generate a loop to rename all the fields you want...

Rgds

Is there a Field caption in V9 ?

Wed, 16 Dec 2009 21:46:18 GMT

Do you have a short script example of this loop ?

kind regards

Is there a Field caption in V9 ?

gajapathy74 — Wed, 16 Dec 2009 22:14:01 GMT

If I understand your question, you can use the alias in the select ( query ) statement.

Regards

Is there a Field caption in V9 ?

Wed, 16 Dec 2009 22:38:18 GMT

Okay thanks,

That's a static solution, I wonder if it's possible to make a mapping in the script of the fieldname (and not the fields values).

Regards

Is there a Field caption in V9 ?

rwunderlich — Thu, 17 Dec 2009 02:08:58 GMT

You can do a

RENAME FIELDS USING mapname

to do a mass renaming.

-Rob

Is there a Field caption in V9 ?

Thu, 17 Dec 2009 14:59:39 GMT

Thanks,
that's what I was looking for

Regards

Is there a Field caption in V9 ?

Thu, 17 Dec 2009 19:46:02 GMT

It works,

But if I change the name of a field, I have to correct it in some interface objet (actions ... ) :).
I hope, one day we will be able to put two names by QlikView field (the "true" name and a display caption :), I'm almost sure it was planned for the V9.

Anyway, except if somebody have a better idea, I will use a RENAME FIELDS USING mapping, and I'll try not to change the mapping :).

Thanks for your help

Regards

Is there a Field caption in V9 ?

Thu, 29 Apr 2010 09:46:24 GMT

I can not write correctly the "rename using fieldmap.
can I have an example?
I 'm very grateful.

thanks

Is there a Field caption in V9 ?

rwunderlich — Thu, 06 May 2010 07:39:26 GMT

Here's an example of RENAME USING ...

data:
LOAD * INLINE [
Cust, Qty
A, 100
B, 200
]
;

NameMap:
MAPPING LOAD * INLINE [
From, To
Cust, Customer
Qty, Quantity
]
;
RENAME FIELD USING 'NameMap';

-Rob

Re: Is there a Field caption in V9 ?

krishnaroopa — Fri, 09 Dec 2011 10:19:19 GMT

After renaming the field, it is not available in the table object.

The old field becomes unavailable, new field is seen in the fields list

In the image attached, C1 is the field renamed to Customer

regards

KRS