Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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:

 

 

Currently what mine looks like:

 

1 Reply

  • Hi Anonymous 

     

    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