topic Re: Editing Fields in multiple QVDs in App Development

Editing Fields in multiple QVDs

Anonymous — Mon, 28 Aug 2017 00:02:31 GMT

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

Re: Editing Fields in multiple QVDs

petter — Mon, 28 Aug 2017 08:22:03 GMT

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

Re: Editing Fields in multiple QVDs

Anonymous — Mon, 28 Aug 2017 22:42:27 GMT

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