topic Re: Urgent help in AS400 joining two tables in QlikView

Urgent help in AS400 joining two tables

Mon, 25 Aug 2014 16:11:12 GMT

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))

jer_2011 — Mon, 25 Aug 2014 16:29:10 GMT

hola

intenta con:

Y.DATE = TO_CHAR( Z.DATE,'YYYYDD')

suerte.

alematex — Mon, 25 Aug 2014 16:51:26 GMT

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;