Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Urgent help in AS400 joining two tables

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
201302500
2013036000
2013047
2013058
2013064
2013072

DateCusd_id
01/02/2013AB1
02/02/2013AB1
05/03/2013AB23
08/03/2013AB1
12/03/2013AB23
2 Replies
jer_2011
Creator II
Creator II

hola

intenta con:

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

suerte.

alematex
Partner - Contributor III
Partner - Contributor III

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;