In this video I will demonstrate joining multiple unpivot queries using a real work example.
Пікірлер: 20
@coolharinath60032 жыл бұрын
Brilliant example and explanation Brother 😎
@hadibq Жыл бұрын
The best way to put it so far👍 Thanks it works whether data is aggregate values or not. good way akso to create tall tables for some reasons.
@emmanuelaolaiya3 жыл бұрын
Great work here and thanks so much. This is very useful and helpful.
@aleksandraarsic11004 ай бұрын
Awesome video, thank you!
@darrylw99Ай бұрын
Thanks but how can you have sales amount greater than the inventory amount
@ajaymahato42703 жыл бұрын
Hi James, for the first section where you add the column name for unpivot, how can we write it such that the column name comes from a table or a variable so that it becomes dynamic.
@derekbyers4373 Жыл бұрын
Brilliant…. Thank you
@daciai22012 жыл бұрын
You are the man
@rapo1073 жыл бұрын
Hi james i am great fan of your teaching... could you please make a video on what are the conditions to blend two datasets in microstrategy document? Means is it enough to have one common attribute in two datasets or any other conditions.
@JamesOliver3 жыл бұрын
I have 2 videos I created a while back on data blending that should help. kzbin.info/www/bejne/d2moiHeiltetgZI and also kzbin.info/www/bejne/rma6aJVtlNmge9U
@chrisbertj2 жыл бұрын
Thank you!
@sempowhale31382 жыл бұрын
that was clean
@joshsmart91783 жыл бұрын
Hi, James. For the first section of the video, you unpivoted. What if you want to add the results of that unpivoted data to another query?
@JamesOliver3 жыл бұрын
If I understand you correctly, you should use CTE / WITH statements to do that
@thirumalaip64583 жыл бұрын
please post a video on Microstrategy dossiers in youtube or udemy by updating your course.thanks.
@slavchevbg3 жыл бұрын
Great video! Thanks!
@juancarlosabayo8743 жыл бұрын
how can we know the original column name ? like SalesAmount and Week
@CheCheSmith3 жыл бұрын
Thank you. Learning SQL on my own, is there a place to download large amounts of sample data?
@JamesOliver3 жыл бұрын
CheCheSmith Yes install sql server express and then download the sample database AdventureWorks from Microsoft