Hi, I'm wanting to convert: userid, usersignature, prop1, prop2, prop3,prop* blah,20090303170000,val1, val2, val3, val* into 2 files: userid, usersignature blah, 20090303170000 userid, propname, propvalue blah, prop1, val1 blah, prop2, val2 blah, prop3, val3 ... I've searched these forms and found that there's a component that has been created to do this: 18764 I've only just worked out (as I'm writing this!) that java projects need java components, and perl projects need perl components - which is why that component doesn't appear within my Java project palette. I don't really understand how these components work, so I don't know how easy it would be to make the above component available in Java. Could someone please comment on this? Alternatively, does anyone have any advice on how to get the result that I'm looking for above? The input file will be text, and I'd like the output to be a bulk insert into an Oracle DB. Any help would be appreciated
Thanks for the reply Daztop. Yes, I got this component working. The part that threw me off was that I had to ad the Key column to the tUnpivotRow schema in order to make it work (even after defining it as an input for "Row keys"). See screen shot to see what my final solution was. Once I got past this it was fine. Thanks,
The part that threw me off was that I had to ad the Key column to the tUnpivotRow schema in order to make it work (even after defining it as an input for "Row keys").
At the time of writing the component, there was no way to programatically change the output schema (I don't know if this has now changed). It's therefore unfortunately reliant on the user to set it up in both places.
Glad you got it working.
Hi snehasisrath I have tried to install this component to Talend Studio 6.0.1 and it works, please refers to this article about how to install a custom component to studio.
