Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the March 2024 Fabric update to learn about new features.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |