question about alias in QV

[#1]

Hi,

I have a mutibox in qvw file. And there is a field named [dept]. I select "fields displayed in mutibox" and type label as "department" in "settings in selected field". It works well. But when I click the field, the current select box show "dept: sales".

My question is how to show 'department:sales ' in current select box instead of change the field name when ETL.

Thanks.

[Miguel_Angel_Baeyens]

Hello,

You will have to rename fields in the load script,

Table:LOAD Dept AS Department,...

Besides, you can later label the listbox (not the field) to display in its caption something different.

Hope that helps.

[#3]

Hi,

I know I can rename this in load script.

But, I have almost hundreds of expression which include 'dept'. But the end user want to renamed as department. I don't want to rewrite all of expressions.

[gandalfgray · Accepted solution]

Hi

I have found that if you rename a field in the load script the change is automagically carried out in expressions in the GUI-elements like charts, tables, list boxes etc.

It seems to work both if you use

rename field Dept to Department;

or if you actually change the load statement, replacing the field name from start so to say, for example

replacing

DTab:
LOAD * INLINE [
ID, Dept
1, Sales
2, Production
3, Marketing
];

with

DTab:
LOAD * INLINE [
ID, Department
1, Sales
2, Production
3, Marketing
];

Take a copy of your .qvw and replace Dept with Department, and see if all your expressions in GUI-elements that uses Dept is replaced by Department.

[Miguel_Angel_Baeyens]

Hello,

Then there is an Expression Overview in the Settings menu where you can find and replace code in expressions (for example, the name of a field).

Make a backup file before using the Replace All option in that menu.

Hope that helps.