Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Editing Fields in multiple QVDs

Hi,

Query for editing FIELD names, can this be preset in the Data Load Editor and if so how? Or, do I change each File and each Field individually within the Data Manager?

To change Field heading for multiple (4) QVD files within an APP, can I set this up in Data Load Editor for all to be uniform?

e.g.

Changing CREATE_DATE to Create Date

Changing ASSIGNED_TO to Assignee

Changing CASE_ID to Case ID

Changing TASK_TYPE to Task Type

Thanks,

DEB

2 Replies
petter
Partner - Champion III
Partner - Champion III

Sure,

in the load editor you can use the RENAME statement like this:

RENAME FIELD CREATE_DATE TO [Create Date];

RENAME FIELD ASSIGNED_TO TO [Assignee];

RENAME FIELD CASE_ID TO [Case ID];

RENAME TASK_TYPE TO [Task Type];

The rename will do a rename of a field that occurs in multiple tables too (key fields).

You could alternatively list them all in one statement. Or you could use a map if you have many fields.

Here is the syntax:

Rename field ‒ Qlik Sense

Anonymous
Not applicable
Author

Much appreciated and I thank you Petter. Worked a charm.