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
ClientID1NameBill
ClientID1Phone1234567
ClientID2NameMark
ClientID2Phone123456

Desired Result:

ClientID Name Phone
ClientID1Bill1234567
ClientID2Mark123456

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

  • knowledgebase/performing_row_denormalisation_using_case_function.txt
  • Last modified: 13/04/2019 16:52
  • by admin