Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I've been trying to work with a data example for over an hour now, but I can't seem to get it to look the way I want it to. My latest attempt involved 600 movie titles, but I only ended up with around 547 rows. I would greatly appreciate it if someone could provide some simple explanations of the step-by-step process to follow in order to successfully merge, unpivot, and possibly remove some rows from the data to create a final table with 600 rows and 4 columns.
Thank you in advance for any assistance you can provide!
Example results:
Currently what mine looks like:
Hi @Koppe08
Pretty much impossible to help you without the data you are using and knowing exactly what it is you are trying to achieve.
regards
Phil
Proud to be a Super User!
User | Count |
---|---|
104 | |
92 | |
88 | |
78 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |