topic Re: How to use an Aliased Field? in QlikView

How to use an Aliased Field?

jgarciaf106 — Wed, 25 Nov 2020 16:16:04 GMT

Hi Experts,

I have the following Question, I hope I could Get any help:

I am Loading the Following:

Load

Field1,

Field2,

Field3 as Field

From Database;

I am wondering how can I accomplish the following as It gives me an error.

Load

Field1,

Field2,

Field3 as Field,

Field + 1 as Result

From Database;

How can I Use the aliased field within the same Script in the way shows above?

Thanks in advanced

Re: How to use an Aliased Field?

Anonymous — Thu, 17 May 2018 22:56:01 GMT

Hey Andres,

The alias "Field" is what gets stored into the new qlik data table loaded into memory, you're still pulling from the Database which retains its names. So for this, you simply need to reference Field3 instead of Field.

Load

Field1,

Field2,

Field3 as Field,

Field3 + 1 as Result

From Database;

If you are trying something a little bit more complicated, you can use a Preceding Load‌ to access the created table and add new custom fields.

Load

Field + 1 as Result

;

Load

Field1,

Field2,

Field3 as Field

From Database;

Re: How to use an Aliased Field?

Anonymous — Fri, 18 May 2018 02:35:47 GMT

by Preceding load:

//preceding load above your original code

Load

Field1,

Field2,

Field3,

Field + 1 as Field4;

// your original code

Load

Field1,

Field2,

Field3 as Field

From Database;

by Resident load

// your original code

Original:

Load

Field1,

Field2,

Field3 as Field

From Database;

//preceding load below your original code

Load

Field1,

Field2,

Field3,

Field + 1 as Field4

RESIDENT Original; // Resident keyword

Re: How to use an Aliased Field?

keerthika — Fri, 18 May 2018 05:25:15 GMT

Hi,

You cann't able to use alise name in condition and here you are fetching datas directly from table so its not possible . Create that field as a separate table and use it

load *, Field + 1 as result;

load Field1,Field2,Field3 as Field

from table;