Merge tables

[lpro87]

Good afternoon, dear experts and developers.
I am using joomla 3.10, Fabrik 3.1
Is it possible to merge 2 tables into one?
I have created 3 sheets: List1 and List2 and also AllList
Each sheet has 3 identical fields - List1 (ID, Name, Data), List2 (ID_2, Name_2, Data_2) and AllList (ID_all, Name_all, Data_all).
How to get the result filled in List1 and List2 in AllList?

List1
ID Name Date
1 Mark 07-04-2022

List2
ID Name Date
1 Molly 08-04-2022

AllList
ID Name Date
1 Mark 07-04-2022
2 Molly 08-04-2022

 

[troester]

Depends on your setup and design strategy (see also http://fabrikar.com/forums/index.php?wiki/design-strategy/)

If it is for display only you can create a MySQL view.

You can use only AllList with an additional field/element keeping the "category" (list1/list2 or m/w or whatever) with pre-filters.

Obviously it's not "identical fields", this would be with identical column names

 

[lpro87]

Thank you. Me approached the mechanism - Joining some data.
List - List1 - Data - Join --- (Merged data with AllList)
List - List2 - Data - Join --- (Merged data with AllList)