Load data on field and date

[marty_32]

Dear QlikSense Community,

i have a "problem" and wanted to know if there is an alternative to what i thought of. I couldn't find any "solution" for my topic so i'm creating this subject.

The reason why is that table1 is pretty huge and i wanted to reduce the work load and only want to load the data i really need.

I have 2 tables and 1 resulting table.

table1: is for production values for each sort and each date

table2: is for each sort and its start production date 

table3: is the resulting table i want to have

You may wonder why there are production values (table1) for Chocolate while the start date (table2) is later.

This is due to a change in the department and also the reason for this subject

So my actual question is:
Is there a possibility to load the data in (table1) based on the productionstartdate (table2) without joining those tables?

Thanks in advance!

ProductionValues (table1):

Date	Sort	Produced
01.01.2024	Vanilla	1619
01.01.2024	Chocolate	1834
02.01.2024	Vanilla	1475
02.01.2024	Chocolate	1630
03.01.2024	Vanilla	1696
03.01.2024	Chocolate	1826
04.01.2024	Vanilla	1384
04.01.2024	Chocolate	1539
05.01.2024	Vanilla	1276
05.01.2024	Chocolate	1537
06.01.2024	Vanilla	1268
07.01.2024	Chocolate	1428
07.01.2024	Vanilla	1624
08.01.2024	Chocolate	1606
08.01.2024	Vanilla	1770
09.01.2024	Chocolate	1807
09.01.2024	Vanilla	1375

Start Dates (table2):

Sort	ProductionStartDate
Vanilla	01.01.2024
Chocolate	05.01.2024

Resultint Table:

Date	Sort	Produced
01.01.2024	Vanilla	1619
02.01.2024	Vanilla	1475
03.01.2024	Vanilla	1696
04.01.2024	Vanilla	1384
05.01.2024	Vanilla	1276
05.01.2024	Chocolate	1537
06.01.2024	Vanilla	1268
07.01.2024	Chocolate	1428
07.01.2024	Vanilla	1624
08.01.2024	Chocolate	1606
08.01.2024	Vanilla	1770
09.01.2024	Chocolate	1807
09.01.2024	Vanilla	1375

[marcus_sommer · Accepted solution]

A simple way would be to put table2 into a mapping and using it as where-clause, like:

m: mapping load Sort, ProductionStartDate from table2;

t: load * from table1 where Date >= applymap('m', Sort);

[marty_32]

Thanks for the fast reply. 
I didn't know you could do an applymap in the where clause.

But that seems to work just perfectly!