Problems Joining QVDs

[#1]

Hello;

I am havig problems concatenating and joining QVDs becasue of dates.

I have two (or more) QVDs, all of them have dates and its years and months:

It is possble to have problmes joining or cancatenating them acording to their keys?

QVD1:

load qvd1month

from QVDA;

QVD2:

load Month(qvd1month) as m_qvd1month

from QVDA;

QVD3:

load Num(qvd1month) as n_qvd1month

from QVDA;

QDV1 Result:

qvd1month

jan

feb

mar

apr

may

jun

jul

ago

sep

oct

nov

dec

QDV2 Result:

m_qvd1month

jan

feb

mar

apr

may

jun

jul

ago

sep

oct

nov

dec

QDV3 Result:

n_qvd1month

1

7

12

QVD3 should return values from 1 to 12, but it return only 1,7 and 12. I want to preserve the month name but the join is not correct because of the problem I just described.

Please any help.

Tank you in advance.

Diego.

[swuehl]

Also your QVD2 results are kind of strange (Month of a month should not return a month (or more precisely, not a range of months).

Could you please upload a QVD that shows this qvd1month field?