I think this might be what you are looking for. It depends on whether you want to join on both Factory and Team or just Factory. I joined on both. I also assumed you wanted exact matches only thus the inner join. If you want everything from Item_Make regardless of what is in WorkingHours then you would want to left join. If you want everything from WorkingHours regardless of what is in Item_Make you would want to right join.
If you do not want to join on both Factory and Team then you should rename one of the Team fields so QlikView does not make a link.
Table1:
LOAD Factory,
max_date,
min_date,
Team
FROM
C:\Users\BApperson\Desktop\Item_Make.xlsx
(ooxml, embedded labels, table is Sheet1);
inner join
LOAD date_,
factory as Factory,
hourse,
Team
//F5
FROM
C:\Users\BApperson\Desktop\workingHours.xlsx
(ooxml, embedded labels, table is Sheet1);
TableFinal:
LOAD *,
' ' as Junk
Resident Table1
WHERE date_ >= min_date and date_ <= max_date;
drop table Table1;
This gives you the hours where date is between min date and max date.
Hope this helps!
I also attached a QV document in case you need extra reference.
