You are not logged in.
Announcement
Unanswered posts
|
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Jasper ETL - sequence oparetion on a table problem, please assist
#1 2008-11-05 08:27:53
- ead
- Member
- Registered: 2008-11-05
- Posts: 30
Jasper ETL - sequence oparetion on a table problem, please assist
I have a small problem of something I don't know and haven't found the answer to.
I have a table (MySQL table), and it has many rows.
I want to take each row and compare something on it with the previous row (mean to check row by row with the row before)
Can it be done?
And how can I do it ?
I want for example to see the date in row X and in row X-1, and if there are the same than do Y, else if the sub is something do Z.
How can I do it please?
Offline
#3 2008-11-06 10:04:27
- chris doudet
- Member
- Company: COREP S.A.S.
- Registered: 2007-06-04
- Posts: 105
- Website
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Offline
#4 2008-11-06 10:50:19
- ead
- Member
- Registered: 2008-11-05
- Posts: 30
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Read it
Isn't there a better way doing it? with out coding in Java ?
I mean, what if I need the previous of the prev and so on?
Isn't there some kind of support in ETL for it ?
Offline
#5 2008-11-06 11:00:12
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Hello ead
Can you take an example to explain your request.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#6 2008-11-06 11:13:45
- ead
- Member
- Registered: 2008-11-05
- Posts: 30
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Ok
I have a date row on my table.
Now
I want each time to take the current row and the previous one, and check if the (curr - prev) < time
And if so, to do X
Else
to do Y
How can it be done ?
Thank you for the help!
Offline
#8 2008-11-07 08:46:36
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Hello
Ok
I have a date row on my table.
Now
I want each time to take the current row and the previous one, and check if the (curr - prev) < time
And if so, to do X
Else
to do Y
How can it be done ?
Thank you for the help!
Ok, the [Forum, topic 1790] Read previous row can tell you how to compare the current row with preciou row on tMap, do you have any problem at this step?
Then, use the 'runif' connector and type in the condition on it, tigger x or y.
Best regards
shong
Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!
Offline
#9 2008-11-07 08:49:20
- ead
- Member
- Registered: 2008-11-05
- Posts: 30
Re: Jasper ETL - sequence oparetion on a table problem, please assist
Didn't understood you completely,
I have read that topic, but isn't there a better easier way?!
I mean a GUI way?
As for the "runif" what is that and why do I need it?
Lets say I have 3 cells
X1, X2 and Z
I want Z to be X2 if X2-X1 >number, else Z to be X1
Where X1 is the previous value of X2 in the table
Offline
Pages: 1
- Index
- » Talend Open Studio for Data Integration » Usage, Operation
- » Jasper ETL - sequence oparetion on a table problem, please assist