Performing Row Denormalisation using Case function
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 its incredible flexibility,
The data can be redirected in many ways using multiple criteria, that reduces clutter and makes it easy to understand complex ETL processes
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL forum