topic Re: Renaming a field with a variable in QlikView

Renaming a field with a variable

zagzebski — Sat, 25 Oct 2014 13:19:05 GMT

Is it possible to rename a field with a variable some thing like:

Date as [Update Date-]&$(vTableName)

Basically I want the name of the field to be "Update Date-Revenue" as an example. (The variable in this example being "Revenue")

Thanks in advance,

Steve

Re: Renaming a field with a variable

its_anandrjs — Sat, 25 Oct 2014 13:45:38 GMT

Yes then write like below script and do not use & String concatenation symbol write variable name only $(vTableName) with filed name for more see example.

Let vTableName = 'Revenue';

Load

Date as UpdateDate_$(vTableName)

From Location;

Regards

Anand

Re: Renaming a field with a variable

zagzebski — Sat, 25 Oct 2014 14:21:55 GMT

So simple! Thanks!