You are not logged in.
Announcement
Unanswered posts
|
- Index
- » Usage, Operation
- » Jasper ETL - sequence oparetion on a table problem, please assist
Post a reply
Topic review (newest first)
- ead
- 2008-11-08 18:30:39
Someone?
- ead
- 2008-11-07 08:49:20
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
- shong
- 2008-11-07 08:46:36
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 topic:1790 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
- ead
- 2008-11-07 07:53:18
anyone?
- ead
- 2008-11-06 11:13:45
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!
- shong
- 2008-11-06 11:00:12
Hello ead
Can you take an example to explain your request.
Best regards
shong
- ead
- 2008-11-06 10:50:19
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 ?
- chris doudet
- 2008-11-06 10:04:27
- ead
- 2008-11-05 21:46:11
Anyone ???
- ead
- 2008-11-05 08:27:53
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?