conditional join

srota25 — Tue, 28 Apr 2020 21:26:44 GMT

Hi,

Please help me in getting the build logic. My requirement is as below

I have a table which has 10 columns and out of which 4 date columns (Start1,End1,Start2,End2) are there and have another Holiday lookup table which has Holiday date and HolidayName.

I have to calculate two values

diff1 = End1 - Start1 and exclude any holidays between start1 and end1 by referring Holiday lookup table

diff2 = End2 - Start2 and exclude any holidays between start2 and end2 by referring Holiday lookup table

Please help me in getting the logic how to implement it in talend.

Re: conditional join

billimmer — Tue, 28 Apr 2020 21:52:12 GMT

I think this is one of those cases where writing a SQL Statement and running it in a tDbRow component is much easier/cleaner than using Talend's tMap lookups + aggregation. YMMV.

I'm interested to see what other think?

topic Re: conditional join in Talend Studio

conditional join

Re: conditional join