Hi,

I have a requirement where in I have to convert rows values from the data base to columns and generate the output. For example, we have a values in the table,
Product_number             Product_Name               Color             size
111                               BC                                Black             10*10
121                               PC                                 White            20*20

Now I want the output to be,
Prdouct_number           Product_Name              Properties
111                             BC                               Black
111                             BC                               10*10

so forth.
There is no tPivotToRows Component in the version we have downloaded (talend studio 4.0.1)

Please guide me in resolving this. Is there any other way where this can be achieved


Thanks,
Swathi