Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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?