Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
Much appreciated and I thank you Petter. Worked a charm.