Union vs Union ALL Solution
in
The Complete Data Visualization Course with Python, R, Tableau, and Excel
/
Dashboard in Excel – Using the Developer Tab and Creating Radio Buttons in Excel
Can someone please breakdown this solution.
1 answers ( 0 marked as helpful)
Hi Osmiguel!
Thanks for reaching out.
Although the solution contains many lines of code, the idea is to "form" several result sets containing the same fields, and vertically combine them together.
More precisely, we have used as an alias for each result set, or each subset, a different letter (A, B, C, D). Then, we combine these subsets.
Hope this helps but please feel free to get back to us should you need further assistance. Thank you.
Best,
Martin