This example demonstrates how to de-normalize data by looking up key-value pairs.

Source data sample:
ClientID1 Name Bill
ClientID1 Phone 1234567
ClientID2 Name Mark
ClientID2 Phone 123456
Desired result:
ClientID1 Bill 1234567
ClientID2 Mark 123456
Transformation Screenshots:

Data trasformation

Case Statement Example

Case Properties

Groupper Properties

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.