Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Is there a Field caption in V9 ?

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

12 Replies
Not applicable
Author

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

thanks

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

krishnaroopa
Contributor
Contributor

Hi

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