Post a reply

Write your message and submit

Options

Click in the dark area of the image to send your post.

Go back

Topic review (newest first)

rbillerey
2007-11-29 11:50:02

Hi c0utta,

We have just created [Bugtracker] feature 2553. Feedback is welcome !

Cheers

c0utta
2007-11-28 23:27:03

Hi rbillerey,

The functionality of tPivotOutputDelimited is excellent, so are there any plans for an "in line" tPivot component that doesn't require an output file?

Cheers,

c0utta

rbillerey
2007-11-28 12:03:02

Thank you for your support and feedback.

Dazed&Confused
2007-11-28 12:00:29

Ok, it works, thanks a lot!!

I was doing it in my query in SQL and it worked too, but it was much longer.

Thanks again,

Regards.

Dazed&Confused
2007-11-28 11:45:00

Hi,

Thanks, I'm gonna try that right now,

I keep you inform

Regards.

rbillerey
2007-11-28 11:10:28

Hi,

Your issue is a use case for tPivotOutputDelimited :

- Pivot column is "Question"
- Group by : "Id"
- Aggregation : "Answer"
- Operator : First or Last

Hope it helps

ComfortablyNumb
2007-11-27 23:25:28

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.

rbillerey
2007-11-27 18:28:29

Hi,

tPivotOutputDelimited cannot help you in that case because it requires at least 3 columns :

- a pivot column : one output column for each distinct value
- a group by column : one output row for each distinct value
- an aggregation column

Best regards

Dazed&Confused
2007-11-27 17:22:21

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.

Dazed&Confused
2007-11-23 17:43:41

Ok,

I'm sorry, I didn't see it.

Thank you for your quick answer.

Regards.

mhirt
2007-11-23 14:18:18

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,

Dazed&Confused
2007-11-23 13:34:07

Hi,

I would like to use tPivot, so I' ve downloaded the last version of TOS (Milestone release 2.3.0M1) as I thought this component was in it. Unfortunatly, I was wrong. I found this link: [Subversion] r6525, but I don't know how tu use it, to import it in talend. Sorry if this seems stupid, but I'm a little bit lost with TOS for the moment....

Regards.

Board footer

Powered by FluxBB