LOAD certain values in a new column

[sculptorlv]

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]

did u try removing the    '   single quote?

[sunny_talwar · Accepted solution]

Looks good, except a comma is missing:

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

          Value,

          'Dollars' as MoneyName;

SQL SELECT....

[Anonymous]

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