Qlik creating additional rows for table for range between values

[WH_Aqua]

Hello Everyone!

I will try to explain my problem as clearly as possible:

I have a table for production tasks, that stores information about:
Prod_Task_Number, Start_Date, End_Date, Product and others.

I also have a table with info from some other documents with information about:
Product, Date_Stored and others.

I want to have is that those two tables are connected by the Product, which is easy, but also by the dates.

So when filtering Prod_Task_Number, I want the second table to show values only for Product associated with that Prod_Task_Number and Date_Stored for all dates between Start_Date and End_Date.

Is that doable? And was I clear in my question?

Any help would be greatly appreciated 🙂