I want get the eralier timestamp vlaues from the avaliable list
when iam using Aggregate transformation ..its again giving all the list of vlaues
Thanks
Niru
If you have only one minimum per data set I would use the Script component to get it manually.
Thanks.
|||no i have lot of set of duplicate values with in the same column....I have to get the Minimum ones in those sets ..like5
5
3
3
Desired result:
5
5
|||
I still do not understand your scenario.
If you have a data like this:
A B
1 1
1 2
2 7
2 8
You can use the Aggregate component to group on column A and find a minimum on B, so it would produce:
A B
1 1
2 7
Is that what you are looking for?
No comments:
Post a Comment