I need create a left join in a HANA calculated View using a filter in the right tabla a field from de left table, for selecting in the right table the correct record with the graphical tool like this:
I have 2 tables, the table A has one ID and one date and the table B has one ID, datefrom and dateto for sereveral jobs.
I need select form the table B wich job is between the date form the table A using the field DATE from the table A as a filter in the table B (DATEFROM <= DATE, DATETO >= DATE) in the join
I explain with an example
I need with a left join get the following:
0001,XXXX,JOB2 -> DATE = 20200102 DATEFROM =20200101 DATETO 20201231
0002,YYYY,JOB3 -> DATE = 20180506 DATEFROM = 20180101 DATETO = 20181231
0003,ZZZZ,JOB1 -> DATE = 20190108 DATEFROM = 200000101 DATETO = 25000101
Is this posible in the graphical tool?