How to load multiple data sources into ONE collection

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

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: