Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I can not write correctly the "rename using fieldmap.
can I have an example?
I 'm very grateful.
thanks
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
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