Transpose

Posted Jun 28, 20203 min read

Summary
The static transposition function provided by SQL pivot and unpivot is very limited in scope. If you want to use SQL to implement some more complex transposition functions, you will often encounter the problem of too complex statements, and there is also a lack of a standard solution. The SPL language of esProc, because of its flexible syntax and rich function library, can just make up for the deficiencies of SQL. If you want to know more, please go to the Academy to find out: Transpose

..

..

One. Row to column

..

  1. The pivot of the database

..

..

  1. SPL pivot

..

..

..

two. Column to row

..

  1. SQL unpivot

..

..

  1. SPL Column to Row

..

..

three. Bidirectional transpose

..

..

..

..

..

four. Dynamic transposition

..

  1. The pivot function automatically generates columns

..

..

  1. Dynamic Transposition

..

..

..

  1. Complex static rank transposition

..

..

  1. Complex dynamic rank transposition

..

..

Fives. Transpose simultaneous column calculation

..

..

..

six. Transfer of related columns between tables

..

  1. The child table is dynamically inserted into the main table

..

..

  1. Multi-column related column transfer

..

..

..

Seven. Columns

..

..

..

..

Transpose.pdf