Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add column to a table

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.

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

You can use:

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

You can use:

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

Not applicable
Author

tq...

Anonymous
Not applicable
Author

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;