Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Koppe08
New Member

Mergeing Three Tables

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:

 

recap 4.png

 

Currently what mine looks like:

 

Merge data.png

1 REPLY 1
PhilipTreacy
Super User
Super User

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



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.