topic How to create a new variable in load statement? in QlikView

How to create a new variable in load statement?

Fri, 09 Jul 2010 10:26:14 GMT

Hi All,

It might be something obvious but I am certainly not aware.

I have different tables for Jan and Feb month data. However it does not have a variable to distinguish it as Jan or Feb.

I try to create a new variable (ex below) but it did not work? Please suggest as this is something urgent.

LOAD ID,
"SALES_QTY",
PROD_NAME,
2008 AS YEAR,
1 AS MONTH
SQL SELECT *
FROM db1."mytable";

Thanks in advance for your any help!

Miguel_Angel_Baeyens — Fri, 09 Jul 2010 10:48:45 GMT

Hello,

Just check the missed semicolon before SQL SELECT statement:


arch25 wrote:
LOAD ID,
 "SALES_QTY",
 PROD_NAME,
 2008 AS YEAR,
 1 AS MONTH;
SQL SELECT *
FROM db1."mytable";

Fri, 09 Jul 2010 10:50:01 GMT

Hi, thanks but I have added that. it still does not work

Miguel_Angel_Baeyens — Fri, 09 Jul 2010 10:54:35 GMT

Hi,

What error is that returning? Syntax looks fine.

Fri, 09 Jul 2010 10:58:52 GMT

What are your settings for Months?

What if you try Month('1') As Month instead of just 1 As Month?