Rename a Field in Script (Is select)

[Natalie]

Hey Guys, I need to change de name of an field, but  im nothing get, is an select:

SQL SELECT field1, field2, field3 from mydatabase;

I tried "as", "mapping", but without success! How Can I change de field name, per example "field1" to "User" in a select?

Thankssss:DDDDD

[sergio0592 · Accepted solution]

Hi,

You can use preceding load for rename with :

Load Field1 as User;

SQL

SELECT Field1 from TABLE;

Take a look here 

https://community.qlik.com/t5/New-to-QlikView/What-is-preceding-load-in-qlikview/td-p/766768