topic Re: Rename a Field in Script (Is select) in QlikView

Rename a Field in Script (Is select)

Natalie — Sat, 16 Nov 2024 01:08:01 GMT

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 — Wed, 04 Mar 2020 16:09:34 GMT

Hi,

You can use preceding load for rename with :

Load Field1 as User;

SQL

SELECT Field1 from TABLE;

Take a look here