topic Re: How can I union or consolidate multiple tables into a single table? in Dataflow

How can I union or consolidate multiple tables into a single table?

miguel — Fri, 19 May 2023 16:40:29 GMT

I have multiple tables (sales data from multiple countries) that I need to union into a single table. How can I accomplish this in Dataflows?

Re: How can I union or consolidate multiple tables into a single table?

miguel — Wed, 10 May 2023 08:53:12 GMT

In Dataflows you have a few ways to union / append data.

Inside the Home ribbon you'll find the "Append queries" option to do so. You can read more about this feature from the link below:

Append queries - Power Query | Microsoft Learn

Re: How can I union or consolidate multiple tables into a single table?

Munawar — Wed, 24 May 2023 08:35:08 GMT

Here is one glinch. When you add calculate colum link add column C and D. It won't add due to null column. Everytime I have to remove null with 0 to get correct result. Some time I forget until after days, we realise that due to null not getting correct sum.

Can you please remove null itself when merge two integer column?

Re: How can I union or consolidate multiple tables into a single table?

miguel — Thu, 25 May 2023 22:59:19 GMT

hey! I'm not sure I follow. This appears to be an unrelated question to the append scenario. Would you mind creating a new thread to go deeper into this topic and showcasing an example of the behavior, please?