Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Joint or Alias

Hello everyone,

Actually, I try to know exactly what it's mean and how to use in qlikview:

(oracle SQL)

Select

    D.field1,  <-----

    field2,

    field3

from

    Data D  <--- they put an alias to use with the first field

AS I Said above, I need an equivalent in qlikview.

Regards

Tags (4)
1 Solution

Accepted Solutions
buzzy996
Honored Contributor II

Re: Joint or Alias

see this,

Select

    field1 as uraliasname,

    field2,

    field3

from

    Data D

2 Replies
balkumarchandel
Valued Contributor II

Re: Joint or Alias

Hi ,

I think you have a query which is extracting data from SQL

you can use join here as well and in preceding script just alias the column names as required.

if you want you can use

Select

    field1,  <-----

    field2,

    field3

from

    Data

if you dont need to join with any table

(we use Alias name in Sql for columns which have same name in both the tables (joined with))

Thanks

BKC

buzzy996
Honored Contributor II

Re: Joint or Alias

see this,

Select

    field1 as uraliasname,

    field2,

    field3

from

    Data D

Community Browser