Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Rename a Field in Script (Is select)

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

Labels (1)
1 Solution

Accepted Solutions
Highlighted
Specialist III
Specialist III

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 

 

View solution in original post

1 Reply
Highlighted
Specialist III
Specialist III

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 

 

View solution in original post