I often have the problem of having a table with patient data that has multiple test results in the same row.  I need to get the data into a format where each test result appears in a separate record with the test name entered into a descriptive field.

For example
Patient#  Creatinine         Potassium          Sodium
Patient1 CreatinineValue  PotassiumValue  SodiumValue

Needs to be
Patient#  TestName  Value
Patient1 Creatinine CreatinineValue
Patient1 Potassium  PotassiumValue
Patient1 Sodium     SodiumValue

The reason this is a problem is that in some cases I may have as many as 2000 columns that need to be factored in this manner.

It looks to me like this is the opposite of what tPivot does.  SAS does this quite easily with about 10 lines of code in PROC Transpose and doesn't require that the column names be explicitly listed in the code.

Is there a Talend component that will do this?  If not, I may need to create one.