Often the data is not stored in just one place, but you need a combination of multiple data sources.
Yes, you could also solve this with multiple collections, but this is not always a handful version.
In the following examples, I will briefly show how to combine data sources that are identical. But also a variant, how to combine several data sources.
As a little extra, I will show you how I add information to this data source in this collection.
IMPORTANT: It is important to mention here that one per data source gives the Data Row Limit. I.e. Per default 500 are adjusted, why then with 2 data sources maximally 1000 elements can be loaded. (from each data source 500)
It is important to mention that the following solution options are only possible if the columns of the tables match exactly by name. Otherwise this will not work. If you need only some columns which are identical, you can select them with ShowColumns(). If the data is identical, but the column name is not, then you can rename them with RenameColumn().
Combine two same data sources into one collection
ClearCollect(colTemp,DataBase1,DataBase2)
Combine two different data sources into one collection
ClearCollect(colTemp,DataBase1,'Delegations Playground')
Add Data from other data sources into one collection
ClearCollect(colTemp,AddColumns(DataBase2,"Animal",LookUp(DataBase1 As TEMP ,TEMP.ID = ID).Animal))
Leave a Reply