Icon

Pivot to Unpivot Advanced Data Transformation

2x2 Pivot Table

Row Fields: Product & Segment

Column Fields: Country & Discount Band

Value Field: Revenue

Fill down & Concatenate

(Row fields 2 columns: Product & Segment)

Transport Table
Fill down

(Column fields 2 columns: Country & Discount Band)

Use First Row as Header

(preparing to unpivot)

Unpivoting
Split back, Column Renaming & Ordering
Column Cleaning
Unpivoted Output

(ready for further data analysis and visualization)


Missing Value Handling
Table Creator
Missing Value
String Manipulation
Column Splitter
Table Transposer
Missing Value
Row to Column Names
Column Renamer
Unpivot
Table Writer
Cell Splitter
Column Resorter
Column Splitter
Missing Value

Nodes

Extensions

Links