All your process tables seem to show the same structure, right?
I would concatenate all process tables into one fact table then (either using CONCATENATE LOAD prefix or this should be done automatically by Qlik when loading your tables. Add a new field that identifies the process:
'Process 1' as process
'Process 2' as process
concatenate 1st 3 table with flag field. and other 2 table keep on association.
Load *,'Process 1' as ProcessName from Table1;
Load *,'Process 2' as ProcessName from Table2;
Load *,'Process 3' as ProcessName from Table3;
Load * from Table4;
Load * from Table5;
In front end
Thank you for your answers.
Each table has different information, however the fields that I indicated in my example are common in each table; of course it´s with different names.
Does the concatenate of the tables work if they have different information?, a join works?
What happens for example if in a table I have two fields that refer to the machine and also to the employee ?, in that case how does qlik sense understand which of the fields should be considered?
For example in the process table2 (this refers to the quality control), I have a field that tells me in which machine i was dried the cloth, and in another field it tells me in which machine the quality was checked.
When you want to filter by machine that dried the fabric or in which machine the quality was checked; How would he do it?
You could use something like a canonical dimension:
Basically you load your records twice, concatenating the two fields into one. Either do this in your fact table (duplicating the records) or create a separate table to link the canonical dimension to your facts.
Latter is probably better if your fact table is containing a lot other fact fields.
HIC is demonstrating it for a canonical date dimension, but you can do the same for machines.
Just tag the machines in the canonical machine table with the usage (create a new field to distinguish 'washing', 'drying' etc.)
If you have a lot of these fields you need to concatenate in one of your tables, you can also use