Merge two tables into one

[reporting_neu]

Hello, everyone,

I have two tables with dependent information.

In one table there are parts with more than one information and in the other table as well. I have to put these together in dependency. But how?

Table1:

RMNr	Prozess	Position	CostItemGroupID	Target time	CostItemGroup	Date	Time
1	1000	1	110	5,0	production	27.09.2021	08:00
1	1000	2	120	2	shipping	28.09.2021	10:00
2	1022	1	110	1,3	production	25.09.2021	07:20
2	1022	1	120	2,8	shipping	28.09.2021	08:00
3	1000	1	110	5,0	production	29.09.2021	08:30

Table2: (Master)

Part	Status	Deadline	Clerk	Target quantity	Desired date	StatusID	WorkOrderType
1000	in production	30.09.2021	HP	100	05.10.2021	1	production
1000	planned	30.09.2021	HP	100	05.10.2021	2	production
1022	in production	30.09.2021	HP	75	05.10.2021	1	production
1022	instructed	30.09.2021	HP	75	05.10.2021	3	production
1000	in production	30.09.2021	HP	36	05.10.2021	1	refurbish

I have to assign the process from Table 1 to each part from Table 2. The part number and process number are identical. However, the process number can appear several times in table 1, just like the part number in table 2.

Several processes must therefore be assigned to a part (from Table 2 from Table 1).
Or the other way around, each process has several parts (from Table 1 to Table 2).

When I use a mapping, I can only assign one value at a time, but I don't get multiple dimensions.

Do you have any advice for me?

[reporting_neu]

Yes of course! That I didn't notice that before.

I have now renamed part and process to process. As a result, there is now agreement.

It now seems to be working too. I still have to validate the data. But it looks good.

[Qlik1_User1]

@reporting_neu Please close this thread, if we are good with the solution.