Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
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?
Solved! Go to Solution.
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:
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?
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?
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:
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Check out the November 2024 Fabric update to learn about new features.
User | Count |
---|---|
5 | |
5 | |
3 | |
3 | |
2 |