Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Gurus
As I am trying to join two tables and one table having value of Date as 'YYYYMM' and another table value has DD/MM/YYYY
I tried this in the where condition but Makedate function is not acceptable in DB AS400, could you please suggest any alternate way to do.
Select *,
From Table Y
Left Join Table Z ON Y.DATE = Makedate(Left(Z.DATE,4),Right(Z.DATE,2))
Date | Value |
---|---|
201302 | 500 |
201303 | 6000 |
201304 | 7 |
201305 | 8 |
201306 | 4 |
201307 | 2 |
Date | Cusd_id |
---|---|
01/02/2013 | AB1 |
02/02/2013 | AB1 |
05/03/2013 | AB23 |
08/03/2013 | AB1 |
12/03/2013 | AB23 |
hola
intenta con:
Y.DATE = TO_CHAR( Z.DATE,'YYYYDD')
suerte.
you can join them IN QLIKVIEW combining sql instructions an qview intructionslike this:
FINAL_TABLE:
SELECT DATE.....
FROM TABLE1;
LEFT JOIN (FINAL_TABLE)
SELECT TO_CHAR(DATE2,'YYYYMM') AS DATE......
FROM TABLE2;