Hi,
Here is the scenario. I have populate the column B based on the Column A.
I have get the min date of ColA and compare it to all the dates in Col A and see if it is less then i have populate in Col B to check whether it should be enddated.
Can you anyone please let me know how to implement this logic using transformer ?
A B
8/11/2011
9/1/2011
10/11/2011
11/12/2011
8/11/2011
how to get min date in transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 89
- Joined: Sat Jul 24, 2010 11:33 pm
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why "using Transformer"? Surely an Aggregator is the correct stage type to get a minimum value. You could also sort the data by date and use a Remove Duplicates to keep only the minimum.
There's also a flaw in your logic.
There's also a flaw in your logic.
- It IS! That's what minimum means!developeretl wrote:I have get the min date of ColA and compare it to all the dates in Col A and see if it is less
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.