Forum Discussion
Data Modelling - Combine Multiple data sources in single attempt
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...
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