Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
If you check out the screen-shot below, what I want to do is have the column (highlighted below) to become the header for all the other columns.
The values in the highlighted column range from 1-13 for each horse. These are the section breaks of the race-course that each horse runs from start to finish.
Any suggestions will be greatly appreciated.
Thanks, Mark.
Solved! Go to Solution.
Hi @Skemaz
You can try pivoting the column with the Don't aggregate option.
Hi @Skemaz
You can try pivoting the column with the Don't aggregate option.
Hi Bhavesh
Many thanks.
After doing what you suggested, I created seperate queries for each section using the original query as my source then removing the other sections and filtering out the null values.
After that I merged all the queries giving me a column for the horses and columns for the sections.
Many thanks for your solution.
Best regrads, Mark.
@Skemaz Mark sorry i am not quite clear on what you asking can you demonstrate what the data should look like if it was as you want it to be?
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |