Add column to a table

[#1]

Hi ALL,

How do i create another field of ABC

  DATE (datedoftssb,'DD-MM-YY') as ABC

with Month only in the same table without have to reextract all again in another qvw.

As far as i know i need to use this

Month(Date#(ABC, 'DD MMM YYYY')) as Month.

Kindly advice.

Thanks.

[Anonymous · Accepted solution]

You can use:

Month(DATE (datedoftssb,'DD-MM-YY')) as Month,

[#3]

tq...

[Anonymous]

You're welcome.

Another option is to use a Preceding Load, like this:

Load

     *,

     Month(ABC) as Month;

Load

     DATE (datedoftssb,'DD-MM-YY') as ABC

     FIELD2,

     FIELD3,

     etc

FROM SOURCE;