Renaming a field with a variable

[zagzebski]

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

[its_anandrjs · Accepted solution]

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

[zagzebski]

So simple! Thanks!