Is there a Field caption in V9 ?

[#1]

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

[#2]

Hi,

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

Best regards,

Janusz

[#3]

Yes but, is that official ?

[#4]

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

[#5]

Do you have a short script example of this loop ?

kind regards

[gajapathy74]

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

Regards

[#7]

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

[rwunderlich · Accepted solution]

You can do a

RENAME FIELDS USING mapname

to do a mass renaming.

-Rob

[#9]

Thanks,
that's what I was looking for

Regards

[#10]

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