I wanted to create a derived table and in one of the columns, I want to partition based on another derived column in the current table.
- Created a derived column (Column1) by partitioning (column2)
- Now I wanted to create a column by partitioning column2(already a derived column),column1