Appending queries
There are some scenarios where we get data with the same structure from different sources, and we want to consolidate that data into a single table. In those cases, we need to append the queries. We have two options to append the queries:
- Append the queries to the first query
- Append the queries as a new query
The latter is prevalent when we follow ETL best practices. We unload all the queries, append the queries as a new query, and load them into the data model. Therefore, all the unloaded queries work as ETL pipelines. This does not mean that the first option is not applicable.
Suppose we have a simple business requirement that can be achieved by appending two or more queries to the first query. In that case, we may wish to use the first option instead. The critical point to note when we're appending queries is that the Table.Combine(tables as list, optional columns as any) function accepts a list of tables. When the column names in the...
