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