Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deb_collins
New Contributor

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
MVP
MVP

Re: Editing Fields in multiple QVDs

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

deb_collins
New Contributor

Re: Editing Fields in multiple QVDs

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