compare current date n previous date n if greater then avoid that row

[#1]

Hi All,

I want to avoid next row in script side . It means suppoase A having 22.09.2013 9:50 and B having 21.09.2013 19.00 then i want to avoid the 2 nd row of b. how to do it in script side.

[MK_QSL]

Load * From TableName

Where Date('B','DD.MM.YYYY') < Date('A','DD.MM.YYYY');

[tresesco]

Try like:

Load

          If(Peek('DateField')<DateField, DateField) as FilteredDate

[#4]

NO I am having like this data:

Field      Date

A           22.09.2013 9:50

B          21.09.2013 19.00

So i have to skip B row.

[MK_QSL]

Temp:

Load * Inline

[

  Field, Date

  A,      22.09.2013 9:50

  B,      21.09.2013 19.00

];

NoConcatenate

Final:

Load

  Field,

  Date

Resident Temp

Where Date > Previous(Date)

Order By Date;

Drop Table Temp;