topic Re: New column from SQL query in QlikView

New column from SQL query

Sat, 28 May 2016 00:58:25 GMT

i'am in traning now

I have this

SQL SELECT AddressLine1,
CustomerKey,
DateFirstPurchase,
EmailAddress,
EnglishEducation,
FirstName,
LastName,
Gender,
Phone,
BirthDate
FROM AdventureWorksDW2014.dbo.DimCustomer;

need to make new column as "AGE" from BirthDate

if I use AGE(today(),BirthDate) as AGE is not make new column:

ErrorSource: Microsoft OLE DB Provider for SQL Server, ErrorMsg: 'today' is not a recognized built-in function name.

SQL SELECT AddressLine1,

CustomerKey,

DateFirstPurchase,

EmailAddress,

EnglishEducation,

FirstName,

LastName,

Gender,

Phone,

BirthDate,

age(today(),birthday) as AGE

FROM AdventureWorksDW2014.dbo.DimCustom

but if I use this function for make dimension is work

please help me........

Re: New column from SQL query

ajsjoshua — Sat, 28 May 2016 05:42:20 GMT

Hi,

Try this

Interval(Now()-BirthDate,'dd hh:mm')

Re: New column from SQL query

MarcoWedel — Sat, 28 May 2016 09:28:09 GMT

‌use a preceding load.

Load age(...) as age, *;

sql select ...

from ...

regards

marco

Re: New column from SQL query

Sat, 28 May 2016 10:01:23 GMT

load age(today(),birthdate) as AGE,*;

is before table select ??

load age(today(),birthdate) as AGE,*;
SQL SELECT AddressLine1,
CustomerKey,
DateFirstPurchase,
EmailAddress,
EnglishEducation,
FirstName,
LastName,
Gender,
Phone,
BirthDate
FROM AdventureWorksDW2014.dbo.DimCustomer;

is not work....

Re: New column from SQL query

Kushal_Chawda — Sat, 28 May 2016 10:04:21 GMT

LOAD *,

age(today(),BirthDate) as AGE;

SQL SELECT AddressLine1,

CustomerKey,

DateFirstPurchase,

EmailAddress,

EnglishEducation,

FirstName,

LastName,

Gender,

Phone,

BirthDate

FROM AdventureWorksDW2014.dbo.DimCustom

Re: New column from SQL query

Sat, 28 May 2016 10:09:05 GMT

Excellent

is work

thanks

Re: New column from SQL query

MarcoWedel — Sat, 28 May 2016 15:18:47 GMT

Yes, but you might have to adjust field names as they are case sensitive.

Hope this helps

Regards

Marco