Data Modelling - Combine Multiple data sources in single attempt

[gisa_sam]

Hi,

I have 5 tables called from different data sources. I need to merge these tables into a single table. The merge query will only merge 2 tables as a time. In this way, it will become a tedious task to merge every single time. Please note that these tables may have additional columns, but I want to merge it using the common columns and, nulls for the additional columns with no data are accepted.

Is there any way where I can merge these 5 tables in a single attempt rather than going for multiple merges?

[BA_Pete]

Hi @gisa_sam ,

I think the answer is probably to not merge them at all - relate them in the Data Model instead.

Without more information around your exact scenario and your desired outcome it's difficult to say if this is feasible, but it's generally my first recommendation whenever anyone raises the issue of a difficult merge.

Pete