This example demonstrates how to de-normalize data by looking up key-value pairs.
Source data sample:
| ClientID | Key | Value |
|---|---|---|
| ClientID1 | Name | Bill |
| ClientID1 | Phone | 1234567 |
| ClientID2 | Name | Mark |
| ClientID2 | Phone | 123456 |
Desired result:
| ClientID | Name | Phone |
|---|---|---|
| ClientID1 | Bill | 1234567 |
| ClientID2 | Mark | 123456 |
Transformation Screenshots:
The beauty of the "Case" function is it's incredible flexibility,
The data can be redirected in many ways using multiple criterias, that reduces clutter and makes it easy to to understand complex ETL processes
Direct link, no registration required.
