Talend community forum / reference other rows in a job

MarWestermann · 2012-06-13 10:06:06

janhess · 2012-06-13 10:13:41

There's no way to determine that row 6 is related to women until you've built a partial relationship. Looks like it may need to be a multi stage process.

MarWestermann · 2012-06-14 12:41:03

Hi thank you much for your hints.

But how could this multi stage process look like?

What I could imagine but are not familiar with is to read all the lines into an array or something like that and use my own java code to iterate over that array and change the description of the groups. Would that be a way and if yes how would the transformation look like?

regards, Marco

mpa · 2012-06-14 15:44:58

I think you should have a look at "recursive queries".

For example the following url:
http://database-programmer.blogspot.be/ … table.html

Regards

MarWestermann · 2012-06-14 16:21:04

@mpa: Thank you. That looks very interesting! Sadly my DB doesnt support that! Any other suggestions? what is with my proposal to write a java code which iterates over an array with the datasets and directly manipulating the fields?

regards Marco

MarWestermann · 2012-06-15 16:53:06

Ok, seems, that I've found a solution.

I send the datasets from my sql table to a tBufferOut. OnComponentOk I use a tJavaFlex to change the descriptions within the buffer. OnComponentOk I use a tBufferIn and write my changed datasets to a file.

regards, Marco

Announcement

Unanswered posts

#1 2012-06-13 10:06:06

reference other rows in a job

#2 2012-06-13 10:13:41

Re: reference other rows in a job

#3 2012-06-14 12:41:03

Re: reference other rows in a job

#4 2012-06-14 15:44:58

Re: reference other rows in a job

#5 2012-06-14 16:21:04

Re: reference other rows in a job

#6 2012-06-15 16:53:06

Re: reference other rows in a job

Board footer