SQL Query | Convert data from columns into Rows | Unpivot

[@LearnatKnowstar]

Register at the below link to get US $100 off for Coursera Plus membership between Sep 8 - Sep 29, 2022. The Coursera Plus membership gets you access to unlimited courses and unlimited certifications! imp.i384100.net/Ke51on

[@broyhill10]

Exactly what I needed. Your lessons are succinct and to the point

[@LearnatKnowstar]

Thank you

[@SabariNathan-eh6iu]

so change the nulls before unpivot query

[@luisdanielhernandez]

Thank you for your valuable contribution. Best regards from Venezuela.

[@LearnatKnowstar]

Glad it was helpful

[@abdrk1]

This is an important query which was asked to me in the NatWest interview

[@LearnatKnowstar]

Thank you

[@atuldhumal8907]

How to do unpivot operation on dynamic columns

[@jtombry]

Thank you. Very helpful. What do you do if you have many columns ( a few hundred) that you need to unpivot? It's not practical to type all of them into a select statement.

[@LearnatKnowstar]

Thank you. In tht case you need to construct a dynamic unpivot query to derive column names. It would be similar to the one described in this video kzbin.info/www/bejne/d5PRZKpmer6CnJY

[@jtombry]

@@LearnatKnowstar Thank you!

[@rajudasari8482]

Can't be dynamic like if data comes for 2021,2022 etc ?. it will add new column or row?

[@LearnatKnowstar]

You will need to create a dynamic unpivot query. You can take the help of the below video to help frame the dynamic query - kzbin.info/www/bejne/d5PRZKpmer6CnJY

[@vlrslh5302]

How to convert all column data types into nvarchar datatype in table

[@narayanac-n7h]

if more columns how to do unpivot?

[@tiagosilva856]

Amazing🇵🇹 cheers from Portugal

[@LearnatKnowstar]

Thank you

[@AakashPanditOfficial]

The UNPIVT_SALES was already created earlier or just an alias?

[@LearnatKnowstar]

It is an alias created as part of the query.

[@vasubhadrasingh1852]

Is it really necessary to create the two aliases? We are not utilising them anywhere

[@sureshallampalli6703]

what if pivot with null ?

[@ginastiofficial]

Thanks 🙏

[@prashantdahiya711]

I can't thank you enough for this, you are awesome 🤩

[@LearnatKnowstar]

Thank you 🙏

[@giorgioniani6296]

great video! appreciate this!

[@LearnatKnowstar]

Glad it was helpful!

[@mario17-t34]

Thanks !!! anybody knows how to unpivot 2+ multiple columns>

[@marnitztaylor9509]

Thank You

[@LearnatKnowstar]

You're welcome