Hello,

The tPivotOutputDelimited is currently only available in Perl project as mentioned on this page : http://talendforge.org/components/index.php
It's available in 2.3.0M1.

Regards,

Hi,

I've a file with 2 columns (answers and questions) like this in input:

name|dupond
name|durand
name|martin
firstname|michel
firstname|robert
firstname|jeanne
sex|M
sex|M
sex|F

I would like to have in output:

name|firstname|sex
dupond|michel|M
durand|robert|M
martin|jeanne|F

Can tPivot be useful to do that? Could you help me and explain to me how to do it?

Thanks a lot.

Regards.

Hi,

Maybe you’ve got a solution to my issue, it would be very helpful.

1.    I execute a query on an Oracle database, and as a result, I get this kind of data:

Id    Question    Answer
1    Name            Juan
2    Name            Jean
3    Name            John
1    Sex              M
2    Sex              M
3    Sex              F
1    Surgery            Yes
2    Surgery            No
3    Surgery            Yes

2.    I want to transform my data like this:

Id    Name  Surgery    Sex
1    Juan    Yes         M
2    Jean    No         M
3    John    Yes         F

3.    Finally, with a tMap component, I want to put this data in an Access Database, which is already created:

Medical history            Patient
   -Id                            -Id
   -Surgery                   -Name
                                   -Sex

Can you show me the way to do it in Talend and/or give me some advice for the part 2.?

Best regards.

Hi,

Thanks, I'm gonna try that right now,

I keep you inform

Regards.

Thank you for your support and feedback.

Hi c0utta,

We have just created [Bugtracker, feature 2553, open] New component : tPivot. Feedback is welcome !

Cheers