topic Re: Adding a Date to a SQL Select in QlikView

Adding a Date to a SQL Select

Mon, 09 Sep 2013 20:36:49 GMT

Hello All,

I am using a SQL Select * from MyView into a resident table. While doing the select, I would like to add a date column to the table (not supplied in the view) to indicate the load date of the record set. This may sound simple, but I'm having trouble finding the right syntax.

Re: Adding a Date to a SQL Select

swuehl — Mon, 09 Sep 2013 20:40:22 GMT

Add a preceding Load:

Load *,

Today() as LoadDate;

SQL SELECT ...

Re: Adding a Date to a SQL Select

rbecher — Mon, 09 Sep 2013 20:52:05 GMT

Syntax for which database..?

Re: Adding a Date to a SQL Select

Mon, 09 Sep 2013 21:04:23 GMT

Thanks for your response. I tried your suggestion and the script threw an error. Here is the statement. The sql select statement by itself runs fine.

TestTable:

Load *,
Today() as LoadDate;
SQL SELECT *
FROM myDB.DBO."MyViewName";

Re: Adding a Date to a SQL Select

swuehl — Mon, 09 Sep 2013 21:09:58 GMT

What does the error message say?

Your DB table does not also have a field named LoadDate, of course.

Re: Adding a Date to a SQL Select

Tue, 10 Sep 2013 12:36:19 GMT

My mistake. I had a bad line above this one (copy / paste error). Everything is ok. Thanks again for your help.