topic Re: LOAD certain values in a new column in QlikView

LOAD certain values in a new column

sculptorlv — Fri, 26 Feb 2016 09:55:00 GMT

Hi,

please help with one question!

I have the following code:

LOAD

IF(Date > Today(), 'new', 'old') AS Date_status,

Value;

Select

a AS Date,

b AS Value

From Table YYY;

I want in LOAD section add one column C with only one value "Dollars".

But I don't know the right syntax ...

Something like:

LOAD

IF(Date > Today(), 'new', 'old') AS Date_status,

Value

'Dollars' AS MoneyName;

Please help with the correct syntax.

Chanty4u — Fri, 26 Feb 2016 10:01:15 GMT

did u try removing the ' single quote?

sunny_talwar — Fri, 26 Feb 2016 10:06:52 GMT

Looks good, except a comma is missing:

LOAD IF(Date > Today(), 'new', 'old') as Date_status,

Value,

'Dollars' as MoneyName;

SQL SELECT....

Anonymous — Fri, 26 Feb 2016 10:08:23 GMT

Just add Comma(,) after Value field in your script