topic Aliasing Fields using Data Definitions in QlikView

Aliasing Fields using Data Definitions

Josh_Good — Thu, 08 Mar 2012 01:19:10 GMT

This videos show how to use a data dictionaryto alias (or rename) fields.

http://youtu.be/Cyjg4LQN9Vo

Aliasing Fields using Data Definitions

magavi_framsteg — Thu, 08 Mar 2012 09:22:10 GMT

Hi Josh.

This is very good.

However, in some cases the datasource field names are coded, i.e TLBKID, TRTTYP.

As a developer I would normally rename the fields on which I do something (where clauses, if statements etc.) in the beginning of the script, for better readability.

Then at the end of the script I could use your technique to rename the rest of the fields.

Kind regards

Magnus Åvitsland

BI Consultant

Framsteg Business Intelligence Corp.

Aliasing Fields using Data Definitions

Josh_Good — Thu, 08 Mar 2012 16:02:06 GMT

Very good point Magnus. This technique can be used in combination with manual aliasing. QlikView will simply keep the manually aliased names and replace the ones that have not been manually aliased.

Regards,

Josh

Re: Aliasing Fields using Data Definitions

pam1990 — Tue, 13 Oct 2020 13:34:56 GMT

This was helpful. Thank You