topic Re: Joint or Alias in QlikView

Joint or Alias

Mon, 04 May 2015 11:42:39 GMT

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

Anonymous — Mon, 04 May 2015 11:47:53 GMT

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 — Mon, 04 May 2015 12:00:26 GMT

see this,

Select

field1 as uraliasname,

field2,

field3

from

Data D